subtotal & Total round to "0" decimal places in matrix chart

[prakash11440278]

HI All,

In matrix chart how to show Total & Subtotal values rounding to zero decimal places and normal row values into 2 decimal places. 

[amitchandak · Accepted 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/

[v-robertq-msft · Accepted solution]

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.

[amitchandak · Accepted 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/