Slicer from 3 different columns

[Anonymous]

Hi,

I need to create a slicer from 3 different columns and need to establish the relationship for all 3 with main table.

[negi007 · Accepted solution]

@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 · Accepted solution]

@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

[Anonymous]

@negi007 ,

Thanks ! really helped me.

Is there a way if I want to add 1 more column in Axis is that possible ?

[v-lionel-msft · Accepted solution]

Hi @Anonymous ,

You may need to do like this. Please refer to my .pbix file.

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[negi007]

@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. 

[Anonymous]

@negi007 ,

I need out put like this. If I pivot the columns my visual will not be like below