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
rajendraongole1's avatar
rajendraongole1
Icon for Super User rankSuper User
1 year ago

Hi karimm  -Please find the attached pbix file with slicer filtering 

 

 

if you choose yes, 

 

 

Hope this works. please check and let know.

 

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

    Hi

    Thank to for your reply. 

    I know how to do this but this doesn't answer my requirement of having a single checkbox. Your solution has a big filter with Yes and No. I need a compact solution where the checkbox behaves like a toggle. 

     

      • 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 )
            )