Preselected slicer - Issue

[Davekk]

Hello Everyone,

I'm currently struggling with a problem with a custom visual called preselected slicer... When I have two of them on one page and I try to filter one of them, all the data disappears from the page... Has anyone experienced something like this or know how to avoid it? In the example below I have filtered 2013.

I will be glad for any help or explanation.

 Thanks,

[Daniel29195 · Accepted solution]

@Davekk 

it could be the dirty status column that you have added is the reason of such issue. 

try using the approach described here for the dirty status  .

https://community.fabric.microsoft.com/t5/Desktop/Date-slicer-in-report-to-default-to-the-latest-ava...

from what i remember ( maybe it could help) , i think you need to have different column for the dirty status per each pre selected slicer. by that i mean, if you war working with 2 slicers, you need to create a table with the following data : 

_PreselectedSlicer = DATATABLE(

    "IsDirtySlicer1", BOOLEAN, "IsDirtySlicer2", BOOLEAN,

    {

        {FALSE(), FALSE()},

        {FALSE(), TRUE()},

        {TRUE(), FALSE()},

        {TRUE(), TRUE()}

    }

)

hope this helps  you out ./ 

If my answer helped sort things out for you, i would appreciate a thumbs up 👍 and mark it as the solution ✅
It makes a difference and might help someone else too. Thanks for spreading the good vibes! 🤠: