Forum Discussion

Das2020's avatar
Das2020
Regular Visitor
3 years ago

Stacked Column Bar Percentage with Sorting

Hi Team, I have this dilemma for stacked column bar. I have this visual where the contract and client has rating based on fees and scopes. As I learn from here you can create a measure that you ca...
komald's avatar
komald
Icon for Helper I rankHelper I
3 years ago

Das2020 , try this

in sheet1 table create new column for sorting purpose
sort_rating= switch(true(),
sheet1[relationship]="rating 1",1,
sheet1[relationship]="rating 2",2,
sheet1[relationship]="rating 3",3,"NA")

and sort relationship on the basis of sort_rating column by asc order.

I hope this will work for you. Thank you

  • Das2020's avatar
    Das2020
    Regular Visitor
    3 years ago

    I also did a similar but using conditional formating from query editor, yes this will sort the relationship but the measure that I created for tooltip will result in all 100% regardless if it's Rating 1, Rating 2, Rating 3 or N/A. Just wondering what can I adjust from the Rating % measure