Switch Function Help

[Anonymous]

Hello All,

Looking for some help here...

I currently have a report that has multiple pages showing the same information, just different granularity. 

As you can see by the photo below, it's rolling up to Brand Name. I also have it rolling up to Username, Manager, Store and SKU. 

Table

I'm trying to get it to where I can have a slicer on the page, and change which level the data rolls up to. 

I'm assuming this can be done with a Switch Function, but I'm unsure of how to get the data from the lookup tables to show the values. 

The data in the Uplift Columns, IV Count, and SKU Effct. all come from one fact table, and the different levels they roll up to are all coming from different lookup tables. 

Is this something that is possible?

The image below is an example of one of the lookup tables. I'm unable to show the data due to privacy issues. 

This lookup table has 133 rows that are all text. The User Name Column has all distinct values, but the Managers are duplicated. 

Lookup

Thanks! 

[jdbuchanan71 · Accepted solution]

@Anonymous 

Your best bet is to use bookmarks that will switch betwen the various view and attach those to buttons to let the users change the display.  Here is a link to a similar question where the solution has a sample file you can take a look at.

https://community.powerbi.com/t5/Desktop/Doubling-up-on-bookmarks/m-p/769112#M370614