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 can put on the tooltip to indicate the percentage of relationship.

Source file

I created a measure that I can use on the tool tip. Unfortunate my boss wants the category to be in Rating 1, Rating 2, Rating 3 and N/A. (by default BI is treating it alphabetically


From my previous experience on fiscal month reporting, I created duplicate table so I can have sorting table.

Created a conditional column

 

Create a relationship from the first table

and the Rating % measure goes broken

2 Replies

  • 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