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.
Hi all,
I'd like to re-order my graph below to show producers ranked per their quality performance
e.g if reordered by quality performance Producers G23 and G4 would be the first 2 producers on the column chart. Then conversely G28 would be the ranked the worst.
Unsure on how best to approach this and whether this is possible.
Solved! Go to Solution.
Hi @Matho101 ,
First create a column as below:
Rank = RIGHT('Table'[Producer ],LEN('Table'[Producer ])-1)
Then duplicate "Producer"column :
_Producer = 'Table'[Producer ]
Make it sort by "Rank":
And you will see:
For the related .pbix file,pls see attached.
Best Regards,
Kelly
Did I answer your question? Mark my post as a solution!
Hi @Matho101 ,
First create a column as below:
Rank = RIGHT('Table'[Producer ],LEN('Table'[Producer ])-1)
Then duplicate "Producer"column :
_Producer = 'Table'[Producer ]
Make it sort by "Rank":
And you will see:
For the related .pbix file,pls see attached.
Best Regards,
Kelly
Did I answer your question? Mark my post as a solution!
@Matho101 , Not very clear. Check if there is an option on three dots to change sort.
Or you create 100% stacked with the stacked line visual (Create a % of subtotal measure)
Or add a line with a required measure for Sort(Rank column of Quality Performance. And use that for sorting. Make like color same a background color so not much visible
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 |
---|---|
110 | |
94 | |
80 | |
66 | |
58 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |