Power BI Slicer

[BIswajit_Das]

Hello team need to figure out a way to use values from 2 columns used as slicer options in a slicer
Here used table is

id	gender	age
a	m	23
b	m	23
c	f	22
d	t	20
e	f	20

I want to make a slicer with the values based on both gender and age column
E.g

When i clicked on the slicer value it should filter the above table
Thanks

[Anonymous · Accepted solution]

Hi  @BIswajit_Das ,

Here are the steps you can follow：

1. In Power Query , copy the Table.

Table(2)：

Select [age] and [id] – Home – Remove Columns.

Right-click the mouse -- Remove Duplicates:

Table(3)：

Select [gender] and [id] – Home – Remove Columns.

Right-click the mouse -- Remove Duplicates:

Table(3)：

Select [gender] and [id] – Home – Remove Columns.

Right-click the mouse -- Remove Duplicates:

2. Home – Append Queries -- Append Queries as new .

Select both [gender] and [age] -- Right-click the mouse – Merge Columns.

3. Create measure.

Measure =
var _select=SELECTEDVALUE('Append1'[Merged])
return
IF(
    _select in SELECTCOLUMNS('Table',"age",CONVERT('Table'[age],STRING)) || _select in SELECTCOLUMNS('Table',"gender",'Table'[gender]),1,0)

4. Place [Flag]in Filters, set is=1, apply filter.

5. Result:

Best Regards,

Liu Yang

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

[BIswajit_Das]

Thanks for responding
But I need to use both columns values as options in the slicer as i mentioned on the post

[mlsx4]

Yes, I know. But Power BI just nests two columns... It doesn't allow multiple columns in a slicer

[BIswajit_Das]

Isn't there any workaround or any tricks

[mlsx4]

I don't think so, but... Let's wait and see if anyone knows something

[johnyip]

you could use a nested slicer, or simply utilize two slicers: one for gender another for age.

[mlsx4]

Hi @BIswajit_Das 

I think that the maximum you can achieve is a nested slicer (if you only want one slicer):