Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
I have a stacked bar chart. Employees on the Y Axis. Success Rate (measure) as the values.
When I add the axis and values - the X axis shows properly as a percentage. (0%, 50%, 100%) As soon as I add a category to the Legend so that my bars are a different color, the X axis changes to a decimal (0.0, 0.5, and 1.0).
Of course I have one chart where I must have figured out how to maintain the percentage formatting, but I cannot replicate it.
All of my rates are set as percentages. The data labels continue to show up properly as percentages.
Any idea where I can fix the X axis to maintain the default variable formatting of percentage?
Solved! Go to Solution.
@dkernen I believe I have found the source of the issue. I noticed that you are using Calculation Groups. I won't pretend to understand all the nuances related to formatting with Calc Groups, but I will say that there are some documented issues related to Calculation Groups affecting format strings of existing measures unexpectedly.
Here is just one thread that is related to the topic:
Long story short, by simply deleting the AuthorizationRate calc item, the issue is fixed. I would recommend evaluating whether that calculation item is truly needed.
@Ashish_Mathur @ebeery Thank you for your speedy and kind replies.
Here is a small sample file.
https://mwtn-my.sharepoint.com/:u:/g/personal/dkernen_mwtn_org/EbALKxR6GlRFijjBWQUPGpcBExOl3dRvPGFch...
@dkernen I believe I have found the source of the issue. I noticed that you are using Calculation Groups. I won't pretend to understand all the nuances related to formatting with Calc Groups, but I will say that there are some documented issues related to Calculation Groups affecting format strings of existing measures unexpectedly.
Here is just one thread that is related to the topic:
Long story short, by simply deleting the AuthorizationRate calc item, the issue is fixed. I would recommend evaluating whether that calculation item is truly needed.
Wow! I am impressed that you found that. That must have taken quite a bit of time and I am so grateful for your efforts! I actually DO need that calculation in my calculation group, but I can change the filter calculation group filter to just affect the one visual that it applies to. (I was being a bit "lazy" and put the calc group filter on the whole page.) You are awesome. Thank you so much!!!
@dkernen it definitely took some detective work haha.
Would you mind marking my answer as a solution if it solved the problem?
Hi,
I cannot pin point the reason. Sorry.
Hi,
Could you share the download link of the file where you are facing this problem. Please also clearly show the problem there.
@dkernen I am not able to reproduce the error, given the scenario you've described.
Do you have a sample file, or at least a screenshot demonstrating the issue?
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
117 | |
109 | |
109 | |
93 | |
69 |
User | Count |
---|---|
173 | |
135 | |
131 | |
96 | |
94 |