Forum Discussion

Davekk's avatar
Davekk
New Member
2 years ago
Solved

Preselected slicer - Issue

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 disappe...
Data Protection
Need Help
Tutorial Requests
  • Daniel29195's avatar
    Daniel29195
    2 years ago

    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-available-date/td-p/3369892

     

     

    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! 🤠:

     

Daniel29195's avatar
Daniel29195
Community Champion
2 years ago

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-available-date/td-p/3369892

 

 

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! 🤠: