Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Hello,
Is it possible to perform the following?
Dataset sample:
Name | Letter | Number |
Test1 | A | 1 |
Test2 | A | 1 |
Test3 | B | 3 |
Test4 | C | 2 |
Test5 | C | 4 |
Test6 | D | 5 |
Test7 | E | 6 |
Test8 | E | 7 |
***The request is such that when they filter the 'Letter' slicer = 'A' and 'Number' slicer = '7', they should see:
Expected Results:
Name | Letter | Number |
Test1 | A | 1 |
Test2 | A | 1 |
Test8 | E | 7 |
Is this possible?
Hi @Rondel ,
If you want to consider using multiple selection, you can use the SELECTCOLUMNS() function:
SELECTCOLUMNS function (DAX) - DAX | Microsoft Learn
Flag =
var _select1=SELECTCOLUMNS('Letter_Slicer',"letter",'Letter_Slicer'[Letter])
var _select2=SELECTCOLUMNS('Number_Slicer',"number",'Number_Slicer'[Number])
return
IF(
MAX('Table'[Letter]) IN _select1 || MAX('Table'[Number]) in _select2,1,0)
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 @v-yangliu-msft ,
Seems that the filter doesn't work when doing multiple selection on just one of the columns:
You need to normalize these columns into their own dimension tables and then feed the slicers from those.
If you want to implement an "OR" logic you need to do that via measures, and use the measures as visual filters.
Hi @Rondel ,
Here are the steps you can follow:
1. Create calculated table.
Letter_Slicer =
DISTINCT('Table'[Letter])
Number_Slicer =
DISTINCT('Table'[Number])
2. Create measure.
Flag =
var _select1=SELECTEDVALUE('Letter_Slicer'[Letter])
var _select2=SELECTEDVALUE('Number_Slicer'[Number])
return
IF(
MAX('Table'[Letter]) = _select1 || MAX('Table'[Number]) = _select2,1,0)
3. Place [Flag]in Filters, set is=1, apply filter.
4. 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
Thank you so much!
How should I go about it if multi-selection was needed for the [Letter] or [Number] column? Seems to not be able to work when trying multi-selection.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
142 | |
75 | |
64 | |
52 | |
47 |
User | Count |
---|---|
219 | |
89 | |
73 | |
66 | |
60 |