Notifications
Clear all
Power BI
2
Posts
2
Users
0
Reactions
133
Views
Topic starter
Hi All,
Does anyone know if it's possible to create a custom unit for visuals whereby if the value is in thousands it displays 'M', millions 'MM', instead of the default 'K' for thousands and 'M' for millions. There doesn't seem to be an option in the formatting settings but has anyone got a workaround in DAX?
Thanks
Posted : 28/05/2021 12:50 pm
Hi Niamh,
This post covers custom number formats in Power BI. However, I tried [<1000000] #,##0,K;[>=1000000] 0.0,,M but it doesn't look like Power BI recognises the scaling criteria.
Mynda
Posted : 28/05/2021 7:38 pm
