Rank with filter

[Anonymous]

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

[Anonymous]

@mangaus1111 one more time thank you very much!

Great work, it works!

[mangaus1111 · Accepted solution]

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.

[Anonymous]

Thank you very much for help. I will be able to answer later as i can't download .pbix from link at current location.

[daXtreme]

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.