Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code FABINSIDER for a $400 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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
Solved! Go to 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
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
Thanks for responding
But I need to use both columns values as options in the slicer as i mentioned on the post
Yes, I know. But Power BI just nests two columns... It doesn't allow multiple columns in a slicer
Isn't there any workaround or any tricks
I don't think so, but... Let's wait and see if anyone knows something
you could use a nested slicer, or simply utilize two slicers: one for gender another for age.
I think that the maximum you can achieve is a nested slicer (if you only want one slicer):
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the February 2025 Power BI update to learn about new features.
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
84 | |
69 | |
68 | |
39 | |
37 |