cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Data_Jules Frequent Visitor
Frequent Visitor

Displaying percentages instead of totals?

Hi everyone,

 

I have a seemingly simple question that appears to be hard to answer. I got survey data. Nominal and ordinal data. I want to make bar charts to visualize how people responded to survey questions. How do I make PowerBI show percentages and not totals?  And what version of PowerBI do I need for hat?

 

And, as follow-up to my question above, I will need those percentages to be dynamic because I will work with filters to display responses from different subsets of respondents. 

 

I find it so weird that PowerBI apparently lacks a simple button for such a basic task. 


Thank you in advance, I am a total PowerBI noobie!

1 ACCEPTED SOLUTION

Accepted Solutions
MCornish Regular Visitor
Regular Visitor

Re: Displaying percentages instead of totals?

Where you have the totals right click it and go to show value as, then percent of grant total.

 

Capture.PNG

This has been in for a while so you will def have this option

5 REPLIES 5
MCornish Regular Visitor
Regular Visitor

Re: Displaying percentages instead of totals?

Where you have the totals right click it and go to show value as, then percent of grant total.

 

Capture.PNG

This has been in for a while so you will def have this option

Data_Jules Frequent Visitor
Frequent Visitor

Re: Displaying percentages instead of totals?

Great, thank you. This is a desktop feature though, isn't it? I can't find that option in the browser version for the life of me. 

MCornish Regular Visitor
Regular Visitor

Re: Displaying percentages instead of totals?

Ha, your right, I never noticed that.

 

Then my suggestion would be to use desktop to design and then publish. I never design in the Service for reasons just like this

Data_Jules Frequent Visitor
Frequent Visitor

Re: Displaying percentages instead of totals?

Right, thank you! I was searching and seaching, no wonder I didn't find it. Thanks four help, appreciated. 

Highlighted
MCornish Regular Visitor
Regular Visitor

Re: Displaying percentages instead of totals?

No problem. Remember to mark either reply as the answer 

Helpful resources

Announcements
Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

PBI Community Highlights

PBI Community Highlights

Check out what's new in the Power BI Community!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 43 members 1,347 guests
Please welcome our newest community members: