Show what is filtered as a visual - but with several filter options

[lewdow]

Hi - I have a report from which the user can select the geography that they wish to view data for. They need to be filters as there are too many layers to accomodate slicers on the report pages. 

I need to show on a report page what has been selected from the lowest level of geography at any point in time. The heirarchy (in order) is:

Country

Macro Organisation

Decision Making Cluster

Account

Cluster

So if someone selects a / multiple cluster in the 'Cluster' filter, I want the measure to show the cluster name(s). However if they don't select a cluster but have selected an / multiple accounts it should show the account name. 

Any idea where to start

[v-shex-msft · Accepted solution]

HI @lewdow,

You can refer to the following link to know how to handle hierarchy level fields, then you can add if statement with filters to check current hierarchy level and return correspond selected items.

Clever Hierarchy Handling in DAX 

Regards,

Xiaoxin Sheng

[VasTg]

@lewdow 

Just noticed the Hierarchy slicer/filter released today as a preview version - Feb 2020. Thats exactly what you need.

https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-february-2020-feature-summary/

[VasTg]

@lewdow 

Look into SELECTEDVALUE and union the output and display them as a table.