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

[F_Reh]

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

Is this possible ? I tried to look at :

1) Y-axis properties of the above bar chart.

2) The four measures linked to the 4 options.

But it seems that the decimal places is fixed for the figures for all 4 options (although the graph does show whole numbers for the two options, and percentage for the other two options it does not seem to allow you to vary the decimal places between these different data types)..

Kindlly advice.

[danextian]

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) 

[vojtechsima]

@F_Reh 
Hey, the issue is that if you leave at Auto, it behaves based on the range between Min and Max values. If Min would be 0 and Max would be 0.9, you would get decimal points for % and whole numbers for the other.

But because you stylize it as %, therefore the gap is too great (as now it's not from 0 to 0.9, but 0-90 for example), it will automatically use whole numbers and %, even tho your labels can display decimal points.

So I am afraid you can't stylise it with the Auto option, if you keep one visual. The easiest solution would be probably to combine field parameters with bookmarks.