Forum Discussion
Rank with filter
Hello Everyone,
I have following set of data:
| Product | Shift | Hours | Date |
| A | RT | 1 | 11/9/2022 |
| B | UPDT | 2 | 11/9/2022 |
| C | TAT | 4 | 11/9/2022 |
| A | RT | 2 | 11/9/2022 |
| B | UPDT | 6 | 11/8/2022 |
| C | TAT | 9 | 11/8/2022 |
| A | UPDT | 8 | 11/9/2022 |
| B | TAT | 2 | 11/8/2022 |
| C | TAT | 3 | 11/8/2022 |
| A | RT | 2 | 11/8/2022 |
| B | UPDT | 3 | 11/9/2022 |
| C | TAT | 6 | 11/8/2022 |
| A | RT | 2 | 11/8/2022 |
| B | UPDT | 5 | 11/8/2022 |
| C | UPDT | 2 | 11/9/2022 |
| A | RT | 10 | 11/8/2022 |
| B | TAT | 4 | 11/8/2022 |
| C | TAT | 3 | 11/8/2022 |
From this data i can create following Stacked column chart:
What i would like to do is to sort chart by the percentage of UPDT for YESTERDAY so i would like to see B as the first bar on the chart.
Question 2: how to attach *.pbix file to post?
REgards
Hi Anonymous ,
see my pbi file
https://1drv.ms/u/s!Aj45jbu0mDVJi0cGoOec2MUFsb0J?e=dNTwSn
1) you create the measure for sorting
2) you put the measure in the tooltips field
3) you sort the x-axis by the sort measure
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
4 Replies
You don't attach. You paste a link to the file that's stored on a shared drive. Don't forget to grant public access.
Hi Anonymous ,
see my pbi file
https://1drv.ms/u/s!Aj45jbu0mDVJi0cGoOec2MUFsb0J?e=dNTwSn
1) you create the measure for sorting
2) you put the measure in the tooltips field
3) you sort the x-axis by the sort measure
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
mangaus1111 one more time thank you very much!
Great work, it works!
