Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
My requires that I show numbers as ## $K, and my data column for a chart has numbers in the thousands, millions and billions.
Chart visuals require numbers in order to show detail labels, but the only way I know to dynamically format numbers creates text that cannot be used as a label.
The Format pane options for Detail Labels gives an fx field for color, but not for Display Units or Decimal Places.
For example, I need the detail labels on this visual to show 1.25 $B with two decimals when equal to or above to a billion, and 820 $M without decimals when below a billion. I can handle the creation of formulas, but there doesn't seem to be a way to enter those formulas anywhere. Help!
Solved! Go to Solution.
Hi @splambo I suggest that you follow my steps in order to ensure that you performed the same actions.
Also attached is an example I made.
1.
2. Just calculate your measure as you need.
3. Modify your format changes based on this measure:
Dax code:
4. Put it on your chart and pay attention to that "display units" is "none" on format options of value:
Result :
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
I got an updated powerbi version and am using the dynamic format to format string measures and it simply seems buggy.
I'm trying to format millions to a shortened format such as $8.9M but the output in the chart's detail labels is inconsistent (and wonky!);
Data Desired result Actual result
8,999,274 $8.9M $9.0M
13,156,240 $13.2M $132M
20,271,133 $20.3M $2202711333M
My Measure formula is:
Measure = MAX(table[column])
My format formula is:
VAR Tot = MAX('table'[column])
RETURN FORMAT(Tot/1000000, "$#,##0.0M")
Hi @splambo I suggest that you follow my steps in order to ensure that you performed the same actions.
Also attached is an example I made.
1.
2. Just calculate your measure as you need.
3. Modify your format changes based on this measure:
Dax code:
4. Put it on your chart and pay attention to that "display units" is "none" on format options of value:
Result :
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
Thank you @Ritaf1983 !
The article mentions this feature is available with PBI Desktop version 2.116.622.0 or later. I have requested this version to my employer and will report back as soon as I can try the solution.
Hi @splambo
From the April version of the desktop, you have this option generically .
please refer to this tutorial:
https://datasavvy.me/2023/04/21/how-to-use-the-new-dynamic-format-strings-for-measures-in-power-bi/
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
98 | |
75 | |
63 | |
62 |
User | Count |
---|---|
135 | |
105 | |
104 | |
80 | |
65 |