Varied decimal column

duvalt — Wed, 22 Jun 2022 15:54:09 GMT

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.

Anything over 10% has to be displayed with a zero decimal place
Between 9.9% & 0.1% needs one decimal place
0.09% to 0.01% should be two decimal places
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

Re: Varied decimal column

ribisht17 — Wed, 22 Jun 2022 17:51:47 GMT

duvalt

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

Regards,

Ritesh

topic Varied decimal column in DAX Commands and Tips

Varied decimal column

Re: Varied decimal column