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.

[v-nmadadi-msft]

Hi @F_Reh ,

Could you please confirm if you've submitted this as an idea in the Ideas Forum? If so, sharing the link here would be helpful for other community members who may have similar feedback.

Thank you for being part of the Microsoft Fabric Community.

[F_Reh]

Not resolved yet. I am not familiar with the technique of combining field parameters with bookmarks.

[v-nmadadi-msft]

Hi @F_Reh ,

If the provided workaround is not suitable or too complex and the required feature is important for your functionality Please consider sharing your suggestion in the Power BI Ideas forum
Fabric Ideas - Microsoft Fabric Community ,
where the product team actively monitors user feedback. Ideas with strong community support are more likely to be considered for future implementation. Posting there helps ensure your request reaches the right audience and contributes to shaping the product roadmap.

[v-nmadadi-msft]

Hi @F_Reh ,

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided by the community members for the issue worked. 

Please feel free to contact us if you have any further questions.

Thanks and regards

[v-nmadadi-msft]

Hi @F_Reh 

May I check if this issue has been resolved? If not, Please feel free to contact us if you have any further questions.

Thank you

[v-nmadadi-msft]

Hi @F_Reh ,

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.

Thank you.

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