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

Help with percentage of total

Hey there!

 

I'm struggling to build a simples (or not) graphic.

 

I have 4 columns that represent a total.

 

By setting to visualize the data as 'percentage of grand total', it does show the percentage of grand total.

 

I'd like to see the percentage of the total by column.

 

Here is how it is:

 

 

 

 

ajuda.PNG    

 

This is what I need (excel):

 

ajuda2.PNG

 

2 REPLIES 2
Super User
Super User

Re: Help with percentage of total

Hey,

 

please excuse, but I do not understand this

 

"I have 4 columns that represent a total" (4 columns / 1 total

 

whereas you columns reflect "I have 4 columns, each representing a part of a separated total" (4 columns / 4 totals)

 

Can you please create a pbix file with sample data (that either allows to create a stacked column chart by a subcategory or a second measure), upload the file to onedrive or dropbox and share the link.

 

Regards,

Tom

Hamburg - Germany
If I answer your question, please mark my post as solution, this will also help others.
I accept Kudos :-), If you find my post helpful.

Proud to be a Datanaut!
mukagalvani Frequent Visitor
Frequent Visitor

Re: Help with percentage of total

 

"please excuse, but I do not understand this

 

"I have 4 columns that represent a total" (4 columns / 1 total

 

whereas you columns reflect "I have 4 columns, each representing a part of a separated total" (4 columns / 4 totals)"

It is showing (4 columns / total)"

 

--

 

If you sum the values on each column you'll have 100%.

 

I'd like to know the (4 columns / 4 total) as the second image shows.

 

X represents the types of customers (PRIME, TOP, BASIC or PLUS)

Y is a binary field. Its fields contains 'Yes' or 'No'. I'd like to know, for each type, the percentage of Yes or No.

 

I'm afraid I can't post the file because it contains sensitive data. Despite that, i'll work something out and post the same case using another example in a few minutes.

 

If I use 'detailed filter' (not sure this is the correct name on Power BI english version) it works.

I used a filter by X row (customer type // Segmento in portuguese) and it showed the BASIC YES AND NO / TOTAL OF BASIC.

 

Now I just need to do this with all customer types.

 

image.png

 

 

Helpful resources

Announcements
New Ranks and Rank Icons in 2020

New Ranks and Rank Icons in 2020

Read the announcement for more information!

New Kudos Given Badges Coming

New Kudos Given Badges Coming

We're rolling out new Kudos Given badges. Find out how many Kudos you've given.

November 2019 Community Highlights

November 2019 Community Highlights

Get an overview of the events and great community content from November.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Solution Authors
Top Kudoed Authors (Last 30 Days)