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.
Hi all,
Using Desktop 2.78.5.
How can I add a different number format to the Column Subtotal in my Matrix that is different from Field Formatting.
My Fields are formatted to to display Thousands. I would like the Column Subtotal to display Millions.
Thanks
-w
Solved! Go to Solution.
Hi,
It is a little different from my dax expression about the field in ISINSCOPE function.
This field should be the [Type] in my test table not the [Value]:
Best Regards,
Giotto Zhi
Hi,
Please try this measure to replace original value:
Measure = IF(ISINSCOPE('Table'[Type]),SUM('Table'[Value])/1000&"K",FIXED(SUM('Table'[Value])/1000000,0)&"M")
The result shows:
Tips: By this way, the value's format will convert to text.
Hope this helps.
Best Regards,
Giotto Zhi
Thanks Giotto,
Definitely on the right track. However, all of my numbers show up as Millions?
I believe my DAX formula is the same as yours?
Hi,
It is a little different from my dax expression about the field in ISINSCOPE function.
This field should be the [Type] in my test table not the [Value]:
Best Regards,
Giotto Zhi
Hey @UncleLewis
There isn't currently an option to format the totals in a matrix. Check out the link below as it very clearly details and outlines what you can and can't do and provides the link for the Ideas page to allow formatting totals and null values:
https://community.powerbi.com/t5/Desktop/Conditional-Formatting-on-Total-and-Null-Values/td-p/313725
If this helps please kudo.
If this solves your problem please accept it as a solution.
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 |
---|---|
114 | |
100 | |
83 | |
70 | |
61 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |