DAX Switch criteria activating different table views / filters

[ElectroHH1]

Hi together,

hope I am doing it right as this is my first question here ever.

I am currently working on a management dashboard for senior management who are quite old and new to all BI related topics. Thus they need very simple ways to get their information and my boss said that I should not use or let them use multiple filterts by themselves.

What is my problem now?

I have a table with sales data and I want to create some kind of switch (single selection) where they can either choose one or another option. This would be easy when it would rever the same underlying table (such as product 1 or product 2), but I need to create a switch to either show product 1 or department 2. Thereby the related criteria are in different star schema tables. 

Until now I was not able to create such a DAX formula that can either select product 1 or department 2 and be used as a filter. Usually I would create a simple mapping table which helps me and can be used as a filter, but I work with a live connection to a DWH where I am not able to create new tables in (no writing access to the data base) thus I need a "in power bi desktop" solution as a DAX code to solve the problem. Hope this is not too confusing.

An alternative would be to create 2 filters and say you are either one or another but not both at the same time or not nothing.

Please help me with my problem.

Have a good day. 🙂

[mlsx4]

Hi @ElectroHH1 

What about creating a button and bookmark to change the selector? It is the idea that camos to my mind right now.

[ElectroHH1]

That is a good idea! Bookmarks sound good! 
Is there a possibility to create a button that has either "Filter Setting 1" or "Filter Setting 2"? So kind of a switch button?

Thanks in advance 🙂

[mlsx4 · Accepted solution]

Hi @ElectroHH1 

I refer to create something like this:

When you click on select product, it shows the slicer with products and the button to come back to departments, and vice versa

In this way, you force the user to select only one of them