Use several slicers on the same column

[TODEI]

Hey,

I would love to compare 4 different units with each other and compare each units actuals and forecast. I created 4 slicers (dropdown) to select each unit individually. Each slicer impacts it's own visuals (this works fine by editing interactions). I also want to have one single table that shows each units values. Sadly, I can't seem to get it to work.

These are my tables:

Here is what my current visuals look like:

Here is what the table should look like:

I tried everything to make the measures used (m3 Actuals and m3 Forecast) show the right data but to no avail.

Do I need to duplicate my Units table and filter them individually?

Thank you!

[Anonymous]

Hi @TODEI ,

Please select each of these four slicers and then select the no impact chart for the table visual one by one, so that the table will no longer be affected by the options of the four slicers above...

Change how visuals interact in a Power BI report

Best Regards

[TODEI]

Hi,

I did that as a solution, sadly the bottom table shows all units (roughly 60 in my case) and not just the 4 that have been chosen using the four slicers.

Thank you, though!

[amitchandak]

@TODEI , Check if role-playing dimension can help

https://radacad.com/userelationship-or-role-playing-dimension-dealing-with-inactive-relationships-in...