Forum Discussion

F_Reh's avatar
F_Reh
Post Patron
1 year ago

Displaying different Decimal points in Graph (whose X-axis units vary on Slicer selected) ?

Good Afternoon,   I have a slicer with 4 options, two of which need to be displayed as whole numbers (with no decimal places) and the other two as percentage (with two decimal places):     ...
Need Help
Show and Tell
Tips and Tricks
danextian's avatar
danextian
Super User
1 year ago

Hi F_Reh 

I am assuming you're not using Field Parameters for measures. Using so would have respected the individual formatting of each measure being referenced. If you're using a conditional measure with a disconnected table, you will need to use dynamic format strings. Example:

IF (
    SELECTEDVALUE ( 'units table'[units] ) IN { "who number 1", "whole number 2" },
    "#,#",
    "0.00%"
)

 Please refer to these:

Create dynamic format strings for measures 

Let report readers use field parameters to change visuals (preview)