Matrix SubTotal Column Different Number Format Than Field Column

[UncleLewis]

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

[v-gizhi-msft]

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

[UncleLewis]

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?

Population_Text = If(ISINSCOPE(Population[Population Est]),SUM(Population[Population Est])/1000&"K",FIXED(SUM(Population[Population Est])/1000000,1)&"M")

Thanks,

-w

[v-gizhi-msft · Accepted 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

[Anonymous]

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.