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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.