Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Reply
dkernen
Resolver II
Resolver II

Stacked Bar Chart - X Axis not maintaining percentage formatting

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?

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

 

ebeery_2-1646190744002.png

 

ebeery_0-1646190428622.png

 

View solution in original post

8 REPLIES 8
dkernen
Resolver II
Resolver II

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

Attached is the fixed file

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

 

ebeery_2-1646190744002.png

 

ebeery_0-1646190428622.png

 

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.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
Ashish_Mathur
Super User
Super User

Hi,

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


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
ebeery
Solution Sage
Solution Sage

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

ebeery_0-1646104592452.png

 

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

Check out the November 2024 Power BI update to learn about new features.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.