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.
Hi, How do I create one slicer based on multiple columns that can help me filter rows?
Here is some sample data:
Name | Segment | Value | Dept view ind | Segment view ind |
John | X | 100 | 1 | 1 |
Sam | Y | 70 | 1 | 0 |
Rachel | W | 50 | 0 | 1 |
Ram | Z | 10 | 0 | 0 |
In the slicer drop down, I need "dept View" and "Segment View".
When I select "Dept View", This should filter "Dept view ind"=1 and when I select "Segment View", This should filter "Segment view ind"=1
Slicer > |
Dept View |
Segment View |
Output for Segment view:
Value = 100+50 = 150 |
Output for Dept view:
Value = 100+70 = 170 |
Thanks,
Shephali
Solved! Go to Solution.
Hi @shephaliB ,
According to your description, I create a sample:
Table:
Slicer table:
Here's my solution, create a measure:
Measure =
IF (
ISFILTERED ( Slicer[Slicer] ),
IF (
SELECTEDVALUE ( Slicer[Slicer] ) = "Dept view"
&& MAX ( 'Table'[Dept view ind] ) = 1,
1,
IF (
SELECTEDVALUE ( Slicer[Slicer] ) = "Segment view"
&& MAX ( 'Table'[Segment view ind] ) = 1,
1
)
),
1
)
Put the measure in the visual filter and select its value to1
Get the result:
Best Regards,
Kaly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @shephaliB ,
According to your description, I create a sample:
Table:
Slicer table:
Here's my solution, create a measure:
Measure =
IF (
ISFILTERED ( Slicer[Slicer] ),
IF (
SELECTEDVALUE ( Slicer[Slicer] ) = "Dept view"
&& MAX ( 'Table'[Dept view ind] ) = 1,
1,
IF (
SELECTEDVALUE ( Slicer[Slicer] ) = "Segment view"
&& MAX ( 'Table'[Segment view ind] ) = 1,
1
)
),
1
)
Put the measure in the visual filter and select its value to1
Get the result:
Best Regards,
Kaly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
John | X | 100 | 1 | 1 | Dept_View |
Sam | Y | 70 | 1 | 0 | Dept_View |
Rachel | W | 50 | 0 | 1 | |
Ram | Z | 10 | 0 | 0 |
John | X | 100 | 1 | 1 | Segment_View |
Sam | Y | 70 | 1 | 0 | |
Rachel | W | 50 | 0 | 1 | Segment_View |
Ram | Z | 10 | 0 | 0 |
@shephaliB , You can create a table with distinct values what have in these two columns, and then you join both of them with that table, one join will inactive that you can active using userelationship
The second option is that, keep the table independent and pass value filter using treatas
https://docs.microsoft.com/en-us/dax/treatas-function
Need of an Independent Table in Power BI - Exclude: https://youtu.be/lOEW-YUrAbE
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 |
---|---|
105 | |
94 | |
75 | |
63 | |
62 |
User | Count |
---|---|
137 | |
105 | |
104 | |
80 | |
63 |