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

We've captured the moments from FabCon & SQLCon that everyone is talking about, and we are bringing them to the community, live and on-demand. Starts on April 14th. Register now

Reply
bbburcu
Frequent Visitor

Slicer dynamically selection

Hi all,

 

I have a question.

Slicer 1 is Apple Slicer 2 should be selected Apple, ZCLK, ZCLZ.

 

How can I show in slicer or column? 

 

bbburcu_0-1667307791956.png

Thanks for your support

Best regards.

 

3 REPLIES 3
bbburcu
Frequent Visitor

Thank you for your answer.

But I can't explain clearly myself, sorry about that.

Yes my tables are not dependent. If apple is selected then it should be automatically select Apple, ZCLZ and ZCLK. And same situation is valid other option (Banana). My table is created UNION function also, it should same count column and then apple and banana is constant but other table has string character called ZCLK and ZCLZ so there is a problem when selection time. How can I handle this problem?

How is the model set up?





Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.






amitchandak
Super User
Super User

@bbburcu , if they are from the same table it should happen automatically.

 

if they are from the different tables then use a measure (not a column) from a common fact in visual level filter and check measure is not blank

refer: https://www.youtube.com/watch?v=cyOquvfhzNM

 

Another approach

How to filter the slicer of a disconnected table: https://youtu.be/cV5WfaQt6C8

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
New to Fabric survey Carousel

New to Fabric Survey

If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.

Join our Fabric User Panel

Join our Fabric User Panel

Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.

March Power BI Update Carousel

Power BI Community Update - March 2026

Check out the March 2026 Power BI update to learn about new features.