Visualization of grouped bar chart with 3 columns

[Anonymous]

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:

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.

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,

[v-danhe-msft · Accepted solution]

Hi @Anonymous,

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

Sample data:

Unpivot the Region A  B C

Set value as Percent of Gand Total:

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

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

Regards,

Daniel He

[Anonymous]

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