cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Visualization of grouped bar chart with 3 columns

Hello, 

 

I am a new user of Power BI and I am facing this issue I couldn´t resolve. My source of data has 6 columns, which are the ones i am showing below:

image.png

I would like to build a visualization that shows me only the grand total of Region A, Region B and Region C in three different columns (bar chart) by Region, so when i click for example 25 of january, it shows me the values of Region A, B and C of that day in ascendent or descendent order. I can not do this, since the grouped bar chart only let me sort by which region I want to be the first or last, and I want that automatically it orders by the greatest value of that day, month or year.

image.png

Here, as an example, I am sorting by "Seller 2", and this is what the chart bar shows me. I want that the black bar be the first, then the red and last the blue. Also I want the references to appear at the bottom of the chart, like in excel

 

By the other hand, I want to do the same but instead of showing me the monetary values, I want the chart bar to show the percentage of each regarding the total of the sum of the 3 regions.

 

I hope to have explained it clearly

Thank you in advance,

1 ACCEPTED SOLUTION
v-danhe-msft
Microsoft
Microsoft

Hi @Anonymous,

Based on my test, you could refer to below steps:

Sample data:

1.PNG

Unpivot the Region A  B C

1.PNG

Set value as Percent of Gand Total:

1.PNG

Use below column to creat bar visual and order by value:

1.PNG

You could also download the pbix file to have a view.

 

Regards,

Daniel He

Community Support Team _ Daniel He
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

2 REPLIES 2
v-danhe-msft
Microsoft
Microsoft

Hi @Anonymous,

Based on my test, you could refer to below steps:

Sample data:

1.PNG

Unpivot the Region A  B C

1.PNG

Set value as Percent of Gand Total:

1.PNG

Use below column to creat bar visual and order by value:

1.PNG

You could also download the pbix file to have a view.

 

Regards,

Daniel He

Community Support Team _ Daniel He
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

Anonymous
Not applicable

Hello Daniel, how are you?

 

First of all I want to thank you very much for your help, this is what I was looking for. Clearly I am not familiar with all the functions that power BI has. I will keep learning in how to use it.

 

Thank you again, my doubt was solved.

 

Best regards!

Joaquín

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.