Forum Discussion
duvalt
4 years agoRegular Visitor
Varied decimal column
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
1 Reply
- ribisht17
Super User