Forum Discussion

TheColdVolcano's avatar
TheColdVolcano
Frequent Visitor
1 year ago
Solved

Between Slicer Hide Unhide

Hello,   I have created 3 slicers, one with style as "Vertical List" (which has 2 values as single select) and the other 2 slicers style as "Between".   What I am trying to achieve here is based ...
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi TheColdVolcano ,

     

    Yes,Visual-level filters work with slicers in Dropdown or List mode, but for "Between" slicers, Power BI does not support filtering visibility using DAX measures. There is no official workaround that toggles visibility of a Between type slicer using another slicer.

     

    Please refer the attached .pbix file for your reference.

     

    If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!

     

    Regards,

    B Manikanteswara Reddy

     

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi TheColdVolcano ,

 

  1. When writing your post or reply, you can see the "Drag or Drop here" option in the bottom as below.

     2.  Click browse, select and attach your sample Power BI file.

  • Make sure to remove any sensitive or personal data before uploading.

           If you are unable to upload the file, you can upload the file to a cloud service (like OneDrive, Google Drive, Dropbox) and share a viewable link instead.

 

Regards,

B Manikanteswara Reddy

TheColdVolcano's avatar
TheColdVolcano
Frequent Visitor
1 year ago

Hello, a quickk update: If I select a dropdown slicer or vertical list slicer than this works

 

DailyMeasure = INT(SELECTEDVALUE(Sheet1[Selection]) = "Daily")
 
WeeklyMeasure = INT(SELECTEDVALUE(Sheet1[Selection]) = "Weekly")
 
The above to measures are applied as necessary. If I select "Daily" from a single select vertical list slicer, it hides the values from Weekly slicer (dropdown or vertical list)... But it does not work with "Between" slicer
  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi TheColdVolcano ,

     

    Yes,Visual-level filters work with slicers in Dropdown or List mode, but for "Between" slicers, Power BI does not support filtering visibility using DAX measures. There is no official workaround that toggles visibility of a Between type slicer using another slicer.

     

    Please refer the attached .pbix file for your reference.

     

    If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!

     

    Regards,

    B Manikanteswara Reddy

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      1 year ago

      Hi TheColdVolcano ,

       

      As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?

      If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.

       

      Please don't forget to give a "Kudos " – I’d truly appreciate it!

       

      Regards,

      B Manikanteswara Reddy

      • Anonymous's avatar
        Anonymous
        Not applicable
        1 year ago

        Hi TheColdVolcano ,

         

        May I ask if you have gotten this issue resolved?

         

        If it is solved, please mark the helpful reply or share your solution and accept it as solution, it will be helpful for other members of the community who have similar problems as yours to solve it faster.

         

        Please don't forget to give a "Kudos " – I’d truly appreciate it!

         

        Regards,

        B Manikanteswara Reddy