cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Reply
rosu
Regular Visitor

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

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!

1 ACCEPTED SOLUTION
v-yiruan-msft
Community Support
Community Support

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

yingyinr_0-1652252741512.png

Best Regards

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

View solution in original post

3 REPLIES 3
v-yiruan-msft
Community Support
Community Support

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

yingyinr_0-1652252741512.png

Best Regards

Community Support Team _ Rena
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
rosu
Regular Visitor

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). 

amitchandak
Super User
Super User

@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

Helpful resources

Announcements
PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors