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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
homils40
Regular Visitor

Showing percent of total in stacked column chart

how do i show percent of total in stacked column chart

9 REPLIES 9
juanpabarrios
New Member

I do have the same issue.

Did you figure out how to solve it?

 

Thanks!

juanpabarrios
New Member

I have the same issue! Did you figure out how to solve it?

Thanks !

v-yuezhe-msft
Employee
Employee

Hi @homils40,

You can select “Percent of grand total” for Value field in Stacked column chart, there is an example for your reference.
1.PNG


Thanks,
Lydia Zhang

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

in the example you have there, i would like to do percentage by month rather than percentage by total. how do i do that?

Hi @homils40,

Please help to share sample data of your table and post expected result.

Thanks,
Lydia Zhang

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

Capture.PNGsee attached stacked column chart. i need to show the numbers a percentage of this category, but not as  a percentage of total

Hi @homils40,

Could you please put raw data in a table and  post expected result in table?

Thanks,
Lydia Zhang

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
PavelR
Solution Specialist
Solution Specialist

@homils40 you can put grand total measure in the visual as tooltip or just use grand total measure as value in visual and turn on data labels.

 

Regards

Pavel

i have 2 measures as a unit. i want to show percentage of those 2 units. how do i do that

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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