Dinamicaly order rank through columns with slicer

[RaphaelDS]

Hello, hope you're doing good (and happy 2023!)

I'm strugling with a problem that looks simple, but I can't really find anything that helps me since this looks like a very specific situation.

Anyways, I created this table and visualization for better understanding. 

         

Soooo, here is what I want to achieve (if possible): 

• Hide columns with value zero;

• Dinamically order the bars and legends from higher to lower by the number of classes;

• AND create some kind of variable to show bars and legends for ONLY the 2 or 3 top values (this looks like the most complicated request).

I'm working with a much larger set of data, but this table works perfect to try to do what I want to, since the slicers filters works exactly like on this one. 

Any help with any of these things will be REALLY aprecciated. 😄 

Thanky'all 

[amitchandak · Accepted solution]

@RaphaelDS , Based on what I got, Unpivot the subject to row.

Unpivot Data(Power Query): https://youtu.be/2HjkBtxSM0g

and then create visual with two axis fields(no legend) , expanded and concatenate label - off

Concatenate Label off : https://youtu.be/QgI0vIGIOOk

[RaphaelDS]

@amitchandak First I need to thank you, it works perfectly for the order of bars, that's amazing! 

Now I can't get rid of the columns with values of zero... 😞 

Maybe because of the software version there are both "X-axis" and "Y-axis" options, not a single "axis" field, if I drag both fields to the same axis no data appears at the visualization... 

So can you help me at this to? Although it's not necessary, but at the real file there are lots of columns with zero (as image below)

and Thanks again! 

[RaphaelDS]

Just did it! 

I created a new column with the condition "if zero then blank" and worked just great.

Really aprecciate your help, thank you @amitchandak  !