Forum Discussion
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 on one of the two values selected in the "Vertical List" slicer, I want to show/hide one of the two "Between" slicer. Is there a way we can achieve that?
Data :
| Username | Selection | Daily Screen Time | Weekly Screen Time | Total Screen Time |
| User1 | Daily | 81 | 366 | 4957 |
| User2 | Weekly | 99 | 438 | 2210 |
| User3 | Daily | 19 | 447 | 644 |
| User4 | Weekly | 34 | 388 | 4964 |
| User5 | Daily | 59 | 500 | 4939 |
| User6 | Weekly | 2 | 206 | 2551 |
| User7 | Daily | 16 | 230 | 1989 |
| User8 | Weekly | 95 | 218 | 438 |
| User9 | Daily | 20 | 342 | 1036 |
| User10 | Weekly | 58 | 297 | 3990 |
| User11 | Daily | 20 | 449 | 2536 |
| User12 | Weekly | 69 | 178 | 1431 |
| User13 | Daily | 16 | 190 | 431 |
| User14 | Weekly | 65 | 253 | 2254 |
| User15 | Daily | 20 | 464 | 1003 |
| User16 | Weekly | 81 | 228 | 3755 |
| User17 | Daily | 54 | 142 | 472 |
| User18 | Weekly | 80 | 347 | 3951 |
| User19 | Daily | 84 | 222 | 2189 |
| User20 | Weekly | 57 | 436 | 3617 |
| User21 | Daily | 75 | 201 | 2599 |
| User22 | Weekly | 61 | 249 | 2329 |
| User23 | Daily | 78 | 480 | 2930 |
| User24 | Weekly | 14 | 497 | 1859 |
| User25 | Daily | 96 | 347 | 1302 |
Visual :
So lets say in the above image, if I choose "Daily" (from Single select Slicer) then only Daily slicer (Between slicer with slider) on the right should be active/visible and if I select "Weekly" (from Single select Slicer) then only Weekly slicer (Between slicer with slider) on the right should be active/visible.
Measures :
If the approach is not correct, I am open to suggestions to achieve the same.
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
12 Replies
refer to the following
https://www.youtube.com/watch?v=Bbr25ZM2EwA&ab_channel=PowerBIHelpline
In Power BI, when a slicer is set to Single Select (like your "Vertical List"), its selected value can only be changed manually by the user. There is no supported way to change that selection dynamically based on another slicer or visual.
This also means you can't show or hide another slicer based on the selection made in a single-select slicer. Power BI doesn’t support dynamically altering the visibility or filter state of one slicer based on another slicer's value.
If you're trying to create a guided user flow or simulate dynamic behavior, the closest workaround would be using buttons with bookmarks to switch between views — but this requires manual setup and isn't truly dynamic.
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Edited the post to give more clarity on what I am looking for.
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?
