Varied decimal column

[duvalt]

Hi,

I'm producing an annual report that has historically been completed in Excel. There is some specific formatting that we would do manually in previous versions and wondered if there was a way to achieve this in PBI using DAX.

1. Anything over 10% has to be displayed with a zero decimal place
2. Between 9.9% & 0.1% needs one decimal place
3. 0.09% to 0.01% should be two decimal places
4. This continues until we reach the lowest value which in this case is 0.0001% as seen below, along with other examples in the second column.

Thanks

[ribisht17]

@duvalt 

different decimal places in one Line chart - Microsoft Power BI Community

Regards,

Ritesh