Forum Discussion

RajaSadagopan's avatar
RajaSadagopan
Regular Visitor
1 year ago
Solved

Custom Display unit for visualisation

Hi Y'all, I want to display the bn as B for all the charts and visualisation, aswell as want to have the auto display feature where if the data is filtered, it automatically changes to M,K o...
Need Help
Show and Tell
Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi RajaSadagopan ,

I create a table as you mentioned.

The only displays of numbers in the Donut chart are the following.

Since Measure for Donut chart in PowerBI can only be placed in tooltips, you can create a Measure.

FormattedAmount =
VAR AmountInBillion =
    MAX ( 'Table'[Amount] ) / 1000000000
RETURN
    FORMAT ( AmountInBillion, "0.0" ) & "B"

If you want to use Dynamic Format Strings for Measures, you can check this official documentation below: Deep dive into the new Dynamic Format Strings for Measures! | Microsoft Power BI Blog | Microsoft Power BI

 

 

Best Regards

Yilong Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.