cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper I
Helper I

Change decimal places for 100% Stacked bar chart

Hi all,

 

           I am running into a problem of changing decimal places for 100% Stacked Bar Chart. Somehow the decimal places are set to be two decimal points regardless of the placeholder for "Value decimal places". Please see the screenshoot below. Could you kindly let me know what the problem is? Is it a bug for visual? Thanks.

 

100%stacked bar chart question.png

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support
Community Support

Re: Change decimal places for 100% Stacked bar chart

Hi @laurelning 

 

Hoook, I changed it to 100% stacked bar chart, and set the value as %GT, not sure if I miss something additional, but modify the decimal number is still doable:

Before:

0006.PNG

After:

0007.PNG

Community Support Team _ Dina Ye
If this post helps, then please consider Accept it as the solution to help the other members find it more
quickly.

View solution in original post

10 REPLIES 10
Highlighted
Super User I
Super User I

Re: Change decimal places for 100% Stacked bar chart

Please check your column/measure formatting in the Modelling ribon:

image.png

 

Kind regards

Djerro123

-------------------------------

If this answered your question, please mark it as the Solution. This also helps others to find what they are looking for.

Keep those thumbs up coming! 🙂





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Highlighted
Super User I
Super User I

Re: Change decimal places for 100% Stacked bar chart

I threw some random values into a stacked bar chart, and wastn' able to reuplciate your issue.  Not sure if it's realted, but why are the X & Y Axis drop downs showing warnings?

 

Are you able to share your data, or a summary of it?

FOrrest



Did I answer your question, or help you along the way?
Please give Kudos or Mark as a Solution!


Proud to be a Super User helping give back to the community!
Thank You!




Helper I
Helper I

Re: Change decimal places for 100% Stacked bar chart

Thanks. But these percentages are the % GT count. I can’t change the formatting in the modeling ribbon.

 

Ling

Highlighted
Helper I
Helper I

Re: Change decimal places for 100% Stacked bar chart

The Y axis is the statement (or item or question). The percentage is the %GT count of responses to each of 1-6 scale point. As to the warnings, they are about Axis/data label font reduced, not very helpful.

 

Ling

Highlighted
Super User I
Super User I

Re: Change decimal places for 100% Stacked bar chart

Hi @laurelning 

 

As far as I'm aware, it's not possible to edit the number of decimal places when using the % of Grand Total feature.

Your best option in this case is to create a DAX measure which will calculate the %. You can then select the number of decimal places to display via the modelling ribbon.

 

Your DAX expression should look something like this:

 

% Responses = 
VAR SumResponses = SUM ( Table1[Responses] )
VAR AllResponses =
CALCULATE ( 
    SUM ( Table1[Responses] ),
    ALL ( Table1[Statement] )
)
VAR Result = DIVIDE ( SumResponses, AllResponses )
RETURN Result

 

 

You'll obviosuly have to change the table and column references to suit your data model.

 

Best regards,

Martyn

 

If I answered your question, please help others by accepting it as a solution.

 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Highlighted
Helper I
Helper I

Re: Change decimal places for 100% Stacked bar chart

Good to know that it is impossible to edit the number of decimal places when using the % of Grand Total feature. Will the feature be updated in the near future?

 

I appreciate your reply. But the DAX formula is not applicable to my case.

 

Thanks.

Highlighted
Community Support
Community Support

Re: Change decimal places for 100% Stacked bar chart

Hi @laurelning 

 

I'm using the %GT in the stacked bar chart, and I can modify the decimal places in Data label of format panel, see below:

1. %GT first:

0003.PNG

2. Edit the data label:

0004.PNG

 

 

 

Community Support Team _ Dina Ye
If this post helps, then please consider Accept it as the solution to help the other members find it more
quickly.
Highlighted
Helper I
Helper I

Re: Change decimal places for 100% Stacked bar chart

Thanks for your reply. But it is the 100% stacked bar chart visual, not the stacked bar chart visual. The Stacked Bar Chart visual allows for an easy editing of decimal places.

 

Ling

Highlighted
Community Support
Community Support

Re: Change decimal places for 100% Stacked bar chart

Hi @laurelning 

 

Hoook, I changed it to 100% stacked bar chart, and set the value as %GT, not sure if I miss something additional, but modify the decimal number is still doable:

Before:

0006.PNG

After:

0007.PNG

Community Support Team _ Dina Ye
If this post helps, then please consider Accept it as the solution to help the other members find it more
quickly.

View solution in original post

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Find your favorite faces from the community presenting at the Power Platform Community Conference!

Upcoming Events

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors
Top Kudoed Authors