Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
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.
Solved! Go to Solution.
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:
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 |
Regards,
B Manikanteswara Reddy
Hello @v-bmanikante , 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 ,
2. Click browse, select and attach your sample Power BI file.
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
Hello, a quickk update: If I select a dropdown slicer or vertical list slicer than this works
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 ,
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 |
Regards,
B Manikanteswara Reddy
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 |
Regards,
B Manikanteswara Reddy
Unfortunately, It does not show me an option mentioned in your first point
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.
refer to the following
https://www.youtube.com/watch?v=Bbr25ZM2EwA&ab_channel=PowerBIHelpline
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 39 | |
| 38 | |
| 38 | |
| 28 | |
| 27 |
| User | Count |
|---|---|
| 124 | |
| 88 | |
| 73 | |
| 66 | |
| 65 |