Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
101 | |
86 | |
64 |