Forum Discussion

karimm's avatar
karimm
Icon for Helper III rankHelper III
1 year ago
Solved

Filtering a slicer using an external single checkbox slicer

Hi there   I have a slicer in my report showing dropdown list of releases from table dimRelease. This table contains ReleaseName and ReleaseStatus (Active or Inactive). The slicer is set to show ...
Need Help
karimm's avatar
karimm
Icon for Helper III rankHelper III
1 year ago

Thank you danextian and rajendraongole1 for your help.

I really appreciate your help.

With the last changes from danextian, it's working now! 

I'm trying to attach the final pbix file so others can use it if needed. But seems not to be possible for me.

 

So I'm listing here the changes that didn't show clearly in danextian GIF :

  1. Updated this data table
    ShowInactiveOption = DATATABLE(
        "Show Inactive", STRING,
        {
            {"Show Inactive"},
            {"No"}
        }
    )
  2. Updated this measure:
    Release Filter =
    VAR ShowInactive = SELECTEDVALUE( ShowInactiveOption[Show Inactive], "No" )
    RETURN
      IF(
        ShowInactive = "Show Inactive",
        1,
        IF( SELECTEDVALUE(dimrel[ReleaseStatus]) = "Active", 1, 0 )
      )