Forum Discussion
Slicers
Dear all
I have one table contains 3 columns as example
col1 = 90
col2= 80
col3 = 70
so I have 3 slicers in the visiual
slicer1 data = A linked to col1
slicer2 data = B linked to col2
alicer3 data = C linked to col3
so
what I want is:
when I select first slicer AND second slicer I want the data to be of col1
when I select second slicer and first slicer I want data of col2
now , when I do
slicer1 and slicer2 data is 90
Slicer2 and slicer1 data is 90 which I want it 80 to be
So how to chech which slicer selected first from the three slicers and formula will be based on what selected first despite selection of other slicers
thanks a lot
5 Replies
Hi AlaIssa ,
It seems you want to dynamically change the data displayed in your report based on the order in which slicers are selected. Power BI does not natively track the order of slicer selections, as slicers typically filter data without regard to selection sequence.
You can submit an idea for it at https://ideas.powerbi.com/ideas/ and wait for users with the same needs as you to vote for you to help make it happen as soon as possible.
How to Get Your Question Answered Quickly
If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .
Best Regards
Community Support Team _ RongtieIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I appreciate your input
is there any idea how can I fix this ?
Thanks a lot
kindly find the demo file
if you select col1 and col2 it gives same data as if you select col2 and col1 while each selection in measure must have different value
Any thoughts how can I manage the situation?
