Capture latest selection in power bi across multiple slicers.

[Anonymous]

Hi, I have to capture last selection out of three slicers in the report.

Slicer 1 (single select), Slicer 2 (single select) and Slicer 3 (single select) are coming form same table. I have to show latest selection out of these three slicers. 

Exampe:

Slicer1	Slicer2	Slicer3
D1	M1	R1
D1	M1	R2
D1	M2	R1
D2	M1	R3

If I select D1 first and then M2 and R1 then result should be R1 in data card.

If I select R1 first and then M2 and D1 then result should be D1 in data card.

If I select M1 and then D2 then result should be D2

if I select R1 and then M1 then result should be M1. Help me out on this issue.

[v-yuezhe-msft]

@Anonymous,

I don't think the above requirement can be achieved in Power BI Desktop as we are not able to detemine which slicer is the last one that we select each time.

Regards,
Lydia

[Anonymous]

Thanks Lydia.