Forum Discussion
Apply specific fields from filter to visual
Hello Community,
on my dashboard, I have one slicer and 2 tables:
Slicer:
| Brands |
| Coca |
| Fanta |
| Sprite |
| Spa |
Fontaine |
Table1:
| Brand | Value |
| Spa | 5 |
| Spa | 4 |
| Spa | 7 |
| Fontaine | 2 |
| Fontaine | 2 |
| Spa | 4 |
| Fontaine | 6 |
| Fontaine | 6 |
Table2:
| Brand | Value |
| Coca | 5 |
| Coca | 4 |
| Fanta | 7 |
| Fanta | 2 |
| Fanta | 2 |
| Fanta | 4 |
| Sprite | 6 |
Sprite | 6 |
What I want to achieve: From the slicer, if the brands Spa and Fontaine are selected, it can only filter table 1. If brands Coca, Fanta and Sprite are selected, they can only filter table2. If for example brands Spa and Coca are selected at the same time in the slicer, the selection Coca should only affect table 2 and the selection Spa should only affect table 1.
Does anyone know how I can achieve this?
Thanks for the help,
Chris
4 Replies
Hello Chrisjr,
I am not sure whether I will be helpful with my half-manual solution, but if the volumes are not huge in your case and the set of brands is quite constant, you can give it a try.
The solution would be:
- you create a new big table by unionizing the tables you have (Table1 and Table2) and arrange a connection with Brands;
- you add a slicer based on the values containing in Brands and two table visuals based on the new big table;
- you filter out manually Coca, Fanta and sprite in the first table visual and Spa and Fontaine - in the second.
Best Regards,
Alexander
Thanks for your reply barritown
The issue here is that if I select only Spa, then the table 2 will return blank value. If I select only the brand Spa, then I want table 1 to be filtered but then table 2 should not be filtered in this example.
(I forgot to mention, in my model, I have on dimension table and one fact table)
Just in case, another "cheap and cheerful" option I had in mind (and kept it there until this moment) is to add two separate slicers based on the Table1[Brand] and Table2[Brand], place them one under another and make them look like one whole slicer via available options in Power BI (grouping, removing title, etc.).
Best Regards,
Alexander
