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.