Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
TheColdVolcano
Frequent Visitor

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 : 

 

UsernameSelectionDaily Screen TimeWeekly Screen TimeTotal Screen Time
User1Daily813664957
User2Weekly994382210
User3Daily19447644
User4Weekly343884964
User5Daily595004939
User6Weekly22062551
User7Daily162301989
User8Weekly95218438
User9Daily203421036
User10Weekly582973990
User11Daily204492536
User12Weekly691781431
User13Daily16190431
User14Weekly652532254
User15Daily204641003
User16Weekly812283755
User17Daily54142472
User18Weekly803473951
User19Daily842222189
User20Weekly574363617
User21Daily752012599
User22Weekly612492329
User23Daily784802930
User24Weekly144971859
User25Daily963471302

 

 

Visual :

 

SlicerManipulation.png

 

 

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 :

 

DailyMeasure = INT(SELECTEDVALUE(Sheet1[Selection]) = "Daily")
WeeklyMeasure = INT(SELECTEDVALUE(Sheet1[Selection]) = "Weekly")
 
Applying these two measures (is 1) to the respective sliders (between slicer) does not work. However, If I change from Between slicer to dropdown slicer from slicer settings then it works. Is there something that can apply to between slicer?
 
 

If the approach is not correct, I am open to suggestions to achieve the same.

1 ACCEPTED 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

 

View solution in original post

12 REPLIES 12
v-bmanikante
Community Support
Community Support

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.

 

vbmanikante_0-1747647259504.gif

 

 

 

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 vbmanikante_0-1747903980497.png" – I’d truly appreciate it!

 

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 ,

 

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

vbmanikante_0-1748082884539.png

     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

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

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 vbmanikante_0-1748513160722.png" – I’d truly appreciate it!

 

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 vbmanikante_0-1748784252206.png" – I’d truly appreciate it!

 

Regards,

B Manikanteswara Reddy

Unfortunately, It does not show me an option mentioned in your first point

Ritaf1983
Super User
Super User

Hi @TheColdVolcano 

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

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

Edited the post to give more clarity on what I am looking for.

Ahmedx
Super User
Super User

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.