Introducing dynamic format strings for DAX measures

Introduction to dynamic format strings feature released in Power BI May 2023, including a few technical details of its implementation.

[tonyocnos]

The level of depth in your videos just keeps astonishing me. Seriously, you are the best that ever happened to PBI users. ❤

[sherifffruitfly]

hah i showed them the multi-comma thing! <3 soooo good to have it native in pbi now!

[momopeaches]

Thanks for the great video! I've watched a few other videos talking about dynamic format strings but this is the only one that tackles possible impact on performance and reusing format strings by calling on the format string of another measure.

One question, is it possible to use dynamic format string to show percentages without the % sign? For example, instead of showing 45.6%, I want it to show only 45.6

[kadirkkkk]

How can i show total by means of each currency like 300USD, 500EUR
And another thing i need is to show my total bank account on a pie chart as USD but labels as each of its own currency

[thesunnynight]

I've notice that using dynamic format string disable the use of tabular editor (since the first release and yet with mast update). Has this happened to you too?

[noahhadro]

It would be great if there was a setting that you could toggle stating that the format string measure will be the same for all rows and therefore calculate one time and then apply to all rows in the column for that measure. For example, I have a disconnected table and slicer where they pick what currency they want to show / convert transaction values to. I know what whatever currency I select, I then want that currency format string so it is dynamic. So I don't need the query to be evaluated each row... just once. I don't know if this is possible but I don't use the format string feature because it is a "nice to have feature" and my users care more about every second of wait time. Love the content. Thanks for sharing.

[AdarshSingh-gwzj]

How to use this in a live connection dataset?

[HaripalSinghThakur]

this is good but problem with this approach is that if you are bring 4-5 formatted KPI's the visual breaks with the error the resources exceeded

[cathrerinezetadrones]

Great video! I just tried to use this feature hoping that it would allow me to properly chart minutes and seconds converted from duration. What the conversion would look like (1.5 = “01:30”) using “nn:ss” . However it seems that it still couldn’t chart this even though I can see the correct result in a matrix. Is there something I am missing or is still not possible?

[nemnoch]

Is it possible to do date formatting with these dynamic format strings?

[kirtitambe]

how to format negative number into (#, .0K), (#, .0M) etc

[vijayvizzu]

Nice explanation, is there way to know which dax function uses storage engine or formula engine

[marcorozzano]

Is it more efficient processing when numbers are noted using exponents (1E3) instead of writing them out fully (1 000), or is it just for legibility ?

[williamrhopkins]

Hi I am trying to work around the lack of a duration data type. I store my durations as decimal numbers. The integer portion of the duration is the number of days and the decimal portion is fractions of days. I want to format a total measure as d hh:mm:ss. DAX does not seem to want to apply format strings like hh:mm:ss to decimal numbers. Any suggestions on how to accomplish this?

[stephencross]

I want to be able to change the colour of a negative value inside a text string. Is this possible with this new feature ?

[zxccxz]

So the most important thing is last. You can’t use this if you use SSAS