Forum Discussion
Slicer from 3 different columns
Hi,
I need to create a slicer from 3 different columns and need to establish the relationship for all 3 with main table.
Anonymous
ok. let's assume your data is like below
Now we will select 3 columns and unpivot these columns. we will get below output.
we can rename colums
below is output visual
I have attached pbix file also
Hi Anonymous ,
You may need to do like this. Please refer to my .pbix file.
Best regards,
Lionel ChenIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
5 Replies
- negi007
Community Champion
Anonymous In this case i suggest you to use powerquery there you can unpivot these 3 columns into one column and then use new column as a slicer to filter data.
negi007 ,
I need out put like this. If I pivot the columns my visual will not be like below
- negi007
Anonymous
ok. let's assume your data is like below
Now we will select 3 columns and unpivot these columns. we will get below output.
we can rename colums
below is output visual
I have attached pbix file also
negi007 ,
Thanks ! really helped me.
Is there a way if I want to add 1 more column in Axis is that possible ?
v-lionel-msftCommunity Support
Hi Anonymous ,
You may need to do like this. Please refer to my .pbix file.
Best regards,
Lionel ChenIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.