Multiple dimensions as one filter

[farinshaikh]

Hello, 

My requirement is to have dimensions as an option in a filter.

Ex. If X,Y,Z are the columns(Dimensions), I want a filter say "Select X/Y/Z" and based on the selection, the visualization should get changed.

Please help me to resolve it.

Thanks in advance.

Farin Shaikh.

[v-shex-msft · Accepted solution]

Hi @farinshaikh,

Based on your requirement, I'd like to suggest you merge these fields to a hierarchy column, then use hierarchy slicer to filter the data.

Reference:

HierarchySlicer

Regard,

Xiaoxin Sheng

[BetterCallFrank]

Hi @farinshaikh

have a look at https://community.powerbi.com/t5/Desktop/Changing-column-graph-displayed-value/m-p/108427/highlight/... for a pattern that you can use.

HTH,

Frank

[BhaveshPatel]

Hi Farin

One of the option in this case is unpivoting the columns and then using the helper table ( only the names of the column) and creating a one to many relationship  of this table with your Main table(unpivoted column) can solve your problem easily. 

[farinshaikh]

Thank you Bhavesh for immediate response.