Forum Discussion
Multiple dimensions as one filter
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.
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:
Regard,
Xiaoxin Sheng
4 Replies
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.
Thank you Bhavesh for immediate response.
Hi farinshaikh
have a look at https://community.powerbi.com/t5/Desktop/Changing-column-graph-displayed-value/m-p/108427/highlight/true#M45588 for a pattern that you can use.
HTH,
Frank
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:
Regard,
Xiaoxin Sheng
