Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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,
Solved! Go to 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
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
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
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
72 | |
70 | |
38 | |
28 | |
26 |
User | Count |
---|---|
99 | |
87 | |
45 | |
43 | |
35 |