Dynamic Slicer Selection

0
votes

I have this table that is feeding into a PowerBI report

select *
from 
    (
        values 
            (1,0),
            (2,0),
            (3,1),
            (4,0),
            (5,0),
            (6,0),
            (7,0),
            (8,0)
    ) as x(num, active)

Then in the report I have a slicer for num:

enter image description here

So - what I am trying to do is have 3 selected in the slicer - because it is marked 1 in the active column of the data BUT all other options in the num slicer should still be visible.

Then tomorrow if the data changes and 4 is marked 1 in the active column then it should be selected rather than 3

.... is this possible?

1
powerbidax

1 Answers