Forum Discussion
Between Slicer Hide Unhide
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
Hi TheColdVolcano ,
Thank you for reaching out to Microsoft Fabric Community
Ritaf1983 Ahmedx Thank you for your quick response.
Unfortunately, Power BI does not support dynamic show/hide of visuals (like slicers) based on slicer values directly. But there is a well-known workaround using bookmarks. However, if your slicer is configured as a Vertical List (single select), you can use the method below:
Step-by-Step Solution Using Measures and Visual Filters
1.Create a static slicer table (either with "Enter Data" or DAX):
SlicerTable = DATATABLE("Slicers", STRING, {{"CUSTOMERS"}, {"PRODUCT"}})
//Add this table as a Vertical List slicer and enable Single Select.
2. Create DAX Measures for Conditional Visibility and Titles
These measures control which slicer appears and what title is shown:
Customer =
IF(SELECTEDVALUE(SlicerTable[Slicers]) = "CUSTOMERS", 1, 0)
CustomerTitle =
IF(SELECTEDVALUE(SlicerTable[Slicers]) = "CUSTOMERS", "CONTINENT", "")
Fore second slicer:
Product =
IF(SELECTEDVALUE(SlicerTable[Slicers]) = "PRODUCT", 1, 0)
Product Slicer Title:
BrandTitle =
IF(SELECTEDVALUE(SlicerTable[Slicers]) = "PRODUCT", "BRAND", "")
3. Apply Visual-Level Filters to Show/Hide Slicers
For the Customer slicer visual:
Add the Customer measure to the Filters on this visual and then set the filter condition to: is 1
For the Product slicer visual:
Add the Product measure to the Filters on this visual and set the filter condition to: is 1
4. Set Dynamic Titles as below:
- Select the Customer slicer visual → Format → Title → Turn on → Click fx
- Use CustomerTitle as the dynamic title
- Do the same for the Product slicer, using BrandTitle.
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
Hi TheColdVolcano ,
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
Hello Anonymous , I tried this solution but it does not work. Is there a way I can upload a file here so that someone can check the same?
Hi TheColdVolcano ,
- 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
