Put many column to slicer

[Anonymous]

Dear friend 

how can i put many column as one slicer 

for example

table

Name	Address	Tel.
aaa	xxxxxa	11111
bbb	xxxxxb	22222
ccc	xxxxxc

slicer 

☑️Name

☑️Address

☑️Tel.

[v-janeyg-msft]

Hi, @Anonymous 

Why put many column as one slicer? Do you want to use slicer to filter the three column names or all the values under the three column names?

Best Regards

Janey Guo

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

[VijayP]

@Anonymous 

Then there is a workaround. Create a dummy Table using Enter Data option in Data Group under Home tab

In that Create Column Headers in the other Table as Row items Name,Address,Tel no. Etc

and using SelectedValue function you can get the required results.

Let me know if this helps! and clicking on Thumbsup always appreciated!

[Anonymous]

@VijayP  could u show that dax ?

[VijayP]

@Anonymous 

You can add all columns in one Slicer (create Hierarchy)

[Anonymous]

@VijayP  thanks for your advice, but need to show it only header as same level