A general filter including others filters

[Anonymous]

Hi all,

I explain my issue by an example : 

So I want that when the user select "L1" in the filter based in a independant table ("L1/L2/Others")  : 

The filter "L1" of the table "Domains actual" is applied on the KPI framed in yellow but for all others KPIs I want that the filter is based on the "L1" of the table "Domains History".

     

For the moment I have created the independant table "L1/L2/Others" but I don't know how to continue..

Can you help me please ? 

Thanks in advance.

[v-juanli-msft]

Hi @Anonymous 

If i understand you correctly, 

1. 

when the user select "L1" in the filter based in a independant table ("L1/L2/Others") ,

The filter "L1" of the table "Domains actual" is applied on the KPI framed in yellow

You want to use the column from independant table ("L1/L2/Others")  to affect the visual used columns from the table "Domains actual" , 

If so, leave the independant table ("L1/L2/Others") as a disconnected table,

You can use the disconnected table to affect your visuals as below:

https://www.blue-granite.com/blog/disconnected-table-power-bi

2. 

for all others KPIs I want that the filter is based on the "L1" of the table "Domains History".

Other visuals used columns from either table should be affected by the slicer used column"L1" of the table "Domains History".

If so, edit interactions for visuals:

https://docs.microsoft.com/en-us/power-bi/service-reports-visual-interactions

Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.