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,
In matrix chart how to show Total & Subtotal values rounding to zero decimal places and normal row values into 2 decimal places.
Solved! Go to Solution.
@prakash11440278 , one of the way if use format with isincope
example
if(isincope (Table[Column]), format([value], "#,###.##", "#,###")
https://www.kasperonbi.com/use-isinscope-to-get-the-right-hierarchy-level-in-dax/
Hi, @prakash11440278
According to your description, I can roughly understand your requirement, I think you can try this measure to replace the original measure in the matrix to achieve this:
This is my test data, you should follow it to make some change to the measure I posted:
New measure = IF(HASONEVALUE('Table'[Name]),FORMAT([Measure],"#,###.00"),FORMAT([Measure],"#,###"))
Then you can go to the matrix to replace the original measure with the new one:
And you can get what you want.
You can download my test pbix file below
If this result is not what you want, you can post some sample data(without sensitive data) and your expected result.
How to Get Your Question Answered Quickly
Thank you very much!
Best Regards,
Community Support Team _Robert Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, @prakash11440278
According to your description, I can roughly understand your requirement, I think you can try this measure to replace the original measure in the matrix to achieve this:
This is my test data, you should follow it to make some change to the measure I posted:
New measure = IF(HASONEVALUE('Table'[Name]),FORMAT([Measure],"#,###.00"),FORMAT([Measure],"#,###"))
Then you can go to the matrix to replace the original measure with the new one:
And you can get what you want.
You can download my test pbix file below
If this result is not what you want, you can post some sample data(without sensitive data) and your expected result.
How to Get Your Question Answered Quickly
Thank you very much!
Best Regards,
Community Support Team _Robert Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@prakash11440278 , one of the way if use format with isincope
example
if(isincope (Table[Column]), format([value], "#,###.##", "#,###")
https://www.kasperonbi.com/use-isinscope-to-get-the-right-hierarchy-level-in-dax/
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 |
---|---|
96 | |
95 | |
83 | |
70 | |
66 |
User | Count |
---|---|
118 | |
106 | |
93 | |
79 | |
72 |