Forum Discussion
How to create flag based on slicer input
Hi,
I have a table similar to the below:
| practice | locality |
| prac1 | North |
| prac2 | North |
| prac3 | East |
| prac4 | East |
| prac5 | East |
| prac6 | West |
| prac7 | West |
| prac8 | West |
I am using the "practice" field in a slicer for my all my visuals except for a a single chart that this slicer does not change (Edit interactions set to "none"). However on this chart I need to filter locality based on the slicer input (To enable users to compare the selected practice with other practices in that locality).
My initial thinking is a DAX flag using selectedvalues and have a new measure that gives 1,0 based on locality. But I can't figure it out. Any help would be greatly appreciated!
Hi msmith61 ,
SELECTEDVALUE() function won't work either once you disable the interaction between two visuals.
My advice is to create an independent slicer table, active or inactive relationships between all tables and this slicer table according to your interactions needs.
Best Regards,
Jay
I finally found a solution to thsi problem from another asked question:
Solved: How to List All Products Listed Under a Category b... - Microsoft Power BI Community
4 Replies
I finally found a solution to thsi problem from another asked question:
Solved: How to List All Products Listed Under a Category b... - Microsoft Power BI Community- amitchandak
Super User
msmith61 , If you want to use the slicer on the measure, you need to use dynamic segmentation
Dynamic segmentation -Measure to Dimension conversion: https://youtu.be/gzY40NWJpWQ
https://www.daxpatterns.com/dynamic-segmentation/
https://radacad.com/grouping-and-binning-step-towards-better-data-visualization hi amitchandak ,
Thanks for the quick reply. Not sure how these links help. I have reviewed and just can't seem to see where this relates to my issue, all of this examples are based on values being within bins. My issue is that I am selecting one single practice but I need my visual to show all practices that are in the same locality as that selected practice.I'm starting to wonder if this is just not possible!
Hi msmith61 ,
SELECTEDVALUE() function won't work either once you disable the interaction between two visuals.
My advice is to create an independent slicer table, active or inactive relationships between all tables and this slicer table according to your interactions needs.
Best Regards,
Jay
