Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello everyone,
I've had an issue regarding slicers that I couldn't solve.
I have a simple table, let's say with a single column called ID. Then I have 2 different slicers that filter that column (ID) (in the real case I must have different slicers filtering the same column because os presentation issues...).
The problem is that the result table I need (the filtered ID column) needs to INCLUDE the results of both slicers.
This is the most precise example I could draw in Excel: https://imgur.com/a/k8Abz
I tried using a calculated column with UNION, SUMMARIZECOLUMS and ALL functions but couldn't hit the result...
Help please?
Solved! Go to Solution.
HI @aszpic,
First of all, current power bi not support to use slicer/filter to create a calculated column/table.
In addition, power bi also not support create multiple slicers from same column to apply filter on original table.
For your requirement, you need to create mutiple selector tables as the source of slicer and writea measure, and drag it to filter to enable filter effect.
Sample:
Tag = var _current=SELECTEDVALUE('Table'[Value]) var _select1=ALLSELECTED(Selector1[Value]) var _select2=ALLSELECTED(Selector2[Value]) Return IF(_current in _select1 || _current in _select2,"Y","N")
Regards,
Xiaoxin Sheng
HI @aszpic,
First of all, current power bi not support to use slicer/filter to create a calculated column/table.
In addition, power bi also not support create multiple slicers from same column to apply filter on original table.
For your requirement, you need to create mutiple selector tables as the source of slicer and writea measure, and drag it to filter to enable filter effect.
Sample:
Tag = var _current=SELECTEDVALUE('Table'[Value]) var _select1=ALLSELECTED(Selector1[Value]) var _select2=ALLSELECTED(Selector2[Value]) Return IF(_current in _select1 || _current in _select2,"Y","N")
Regards,
Xiaoxin Sheng
Oh thanks.
My primitive solution was to copy the "selector" column multiple times, put one of them in each slicer and create a calculated table with UNION functoin of the tables as my result table...
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |