Forum Discussion

Iladan0's avatar
Iladan0
New Member
3 years ago

DAX Filter table using slicer while keeping a specific value no matter what value is selected

Requesting some help with this issue. I have a table with two columns "Scenario" (Baseline, S1, S2, ...) and "Value" (1, 2, 3,..) , I want to filter my table using a slicer on Scenario (the slicer does not include "Baseline") in a way that the row containing Scenario = "Baseline" is always displayed. Please find below the screenshots representing my my situation.
The table:

What I want as a result:

 

Thanks in advance

 

Need Help

1 Reply

  • rsbin's avatar
    rsbin
    Icon for Community Champion rankCommunity Champion
    3 years ago

    Iladan0 ,

    You can create another visual (either a Card Visual or another Table Visual) to display only your Baseline.

    Use the Filter Pane to only show Baseline Scenario.

    Ensure Edit Interactions is disabled between this Visual and your Slicer.

    Then in your Table Visual above, use the Filter Pane to filter out your Baseline Scenario.

    Hope this idea works for you.

    Regards,