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
MitraM
Helper I
Helper I

Cinditional Slicers

Hello.

 

  I have Slicer on my page named "Business Unit" with two values.

 

  Depending on what I choose as Business unit I want different slicer to show on the report.

 

  How can I do this?

 

Thank you;

 

Mitra

1 ACCEPTED SOLUTION

@MitraM It is good candidate to use bookmark and make use of selection pane to hide/visible control on the page. Basically your business unit slicer will be images so that on click you can call different bookmarks. Hope this helps.



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

View solution in original post

4 REPLIES 4
parry2k
Super User
Super User

@MitraM what you mean to show different slicer? Can you give an example?



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Hi @parry2k 

 

Slicer Name = Business Unit

Business Unit Values

A

B

 

If I choose A as Business  Unit I want my 2nd slicer to use VAL Method field

If I choose B as Business Unit I want my 2nd slicer to use INV Method field

 

 

 

Hi @MitraM 

Agree with parry2k's suggestion, here are some articles you can refer to:

Bookmarks and Buttons: Making Power BI Charts Even More Interactive

http://microsoft-bitools.blogspot.com/2018/01/power-bi-bookmarking-feature-update.html

https://exceleratorbi.com.au/create-a-power-bi-slicer-panel/

 

If you have any problem, feel free to let me know.

 

Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

@MitraM It is good candidate to use bookmark and make use of selection pane to hide/visible control on the page. Basically your business unit slicer will be images so that on click you can call different bookmarks. Hope this helps.



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

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.