Forum Discussion
Connect Indepedent Slicers to a Visual
Hello,
I have created slicers that are generally category names and email types that I would want to connect to visual so the visual is able to interact when these email types or category names are selected. I can't seem to work this out. Any advise is appreciated!!
Hello 0803,
Just checking in have you been able to resolve this issue? If so, it would be greatly appreciated if you could mark the most helpful reply accordingly. This helps other community members quickly find relevant solutions.
Please don’t forget to “Accept as Solution” and Give “Kudos” if the response was helpful.
Thank you.
5 Replies
v-ssriganeshCommunity Support
Hello 0803,
Thank you for reaching out to the Microsoft Fabric Forum Community.
I have reproduced your scenario in Power BI Desktop and achieved the expected output successfully.I created slicers using Category and EmailType fields from the same Emails table and added a table visual showing relevant data. Upon selection in either slicer, the visual responded correctly. For your reference, I’m attaching the working .pbix file that demonstrates this behaviour.
If the slicers are based on unrelated tables (e.g: disconnected dimension tables), then the visual won’t filter unless relationships or measures are adjusted. If slicers are from disconnected tables, you can use DAX measures with TREATAS() or USERELATIONSHIP() to bridge slicer selection to the fact table.
But in this case, since the slicers are using the same table (Emails), no extra relationship or DAX is needed.
If this information is helpful, please “Accept as solution” and give a "kudos" to assist other community members in resolving similar issues more efficiently.
Thank you.Hello - The slicers are based on unrelated tables. Generally, I created a table to list the category of emails that I want to use as a slicer to show these categories of emails in the visual. This is because the data table is a count of all emails from these categories that are in different files that I have combined together.
- v-ssriganesh
Hello 0803,
Thank you for the clarification.
Since your slicers are based on unrelated tables, the visuals won’t respond to slicer selections by default because there’s no direct relationship between the slicer table and your main data table.
However, you can still achieve the desired interactivity using a DAX-based solution with TREATAS().
If this helped resolve your issue, please click “Accept as Solution” and consider giving a "kudos" to support other community members.
Thank you.
- danextian
Super User
Hi 0803
No enough information to find out what is exactly going on. I can only assume that the visuals are coming from different tables and the slicer is from a table which relationship doesn't flow to the other tables - for example, the column from a fact table which doesn't have a relationship to another table is used instead of the one from the dimension table.
- v-ssriganesh
Hello 0803,
Just checking in have you been able to resolve this issue? If so, it would be greatly appreciated if you could mark the most helpful reply accordingly. This helps other community members quickly find relevant solutions.
Please don’t forget to “Accept as Solution” and Give “Kudos” if the response was helpful.
Thank you.
