topic Re: Dynamically use different measure with different decimal places based on a slicer in DAX Commands and Tips

Dynamically use different measure with different decimal places based on a slicer

rosu — Thu, 05 May 2022 21:56:12 GMT

Hi,

I am new to Power BI and need some help from the experts. I have two different measure fields that essentially represents same business metrics but with two different DP (Decimal Points). The first measure "% of value" has 8 decimal places and the second one "% of Value 2 dp" has only 2 decimal places. I am trying to dynamically use these columns in a measure "% Value" either the first one or the 2nd one based on a slicer selection. I am able to get it but the issue is Power BI strips the decimal places to 2 during measure calculation. Is there a way to have all 8 decimal places returned without using FORMAT as it converts my measures to string?

Thank you!

Re: Dynamically use different measure with different decimal places based on a slicer

amitchandak — Fri, 06 May 2022 01:15:48 GMT

rosu , Best to use calculation group there you can do different formatting

https://blog.enterprisedna.co/conditional-formatting-in-calculation-groups-power-bi/

Calculation Groups- Measure Slicer, Measure Header Grouping, Measure to dimension conversion. Complex Table display : https://youtu.be/qMNv67P8Go0

Re: Dynamically use different measure with different decimal places based on a slicer

rosu — Tue, 10 May 2022 23:15:02 GMT

Thank you Amit! Even with calculation group I see the measure is being stripped to 2 decimal place when I add it to the conditional calculation (based a separate selection slicer).

Re: Dynamically use different measure with different decimal places based on a slicer

Anonymous — Wed, 11 May 2022 07:06:27 GMT

Hi rosu ,

This is not possible if you want the measure to display values with two decimal places and eight decimal places at the same time in Numeric type according to the slicer option. You can refer to the following blog to make it text type with FORMAT function, but this is something you want to avoid...

Power BI - Dynamic Formatting by Slicer Selection

Best Regards