Stacked Bar Chart - X Axis not maintaining percentage formatting

[dkernen]

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?

[dkernen]

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

[ebeery]

Attached is the fixed file

[ebeery · Accepted 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:

https://community.powerbi.com/t5/Issues/Working-with-tabluar-editor-cause-creation-of-display-folder... 

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.

[dkernen]

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!!!

[ebeery]

@dkernen it definitely took some detective work haha.

Would you mind marking my answer as a solution if it solved the problem?

[Ashish_Mathur]

Hi,

I cannot pin point the reason.  Sorry.

[Ashish_Mathur]

Hi,

Could you share the download link of the file where you are facing this problem.  Please also clearly show the problem there.

[ebeery]

@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?