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.
Here is my data:
Column A | Column B |
Car 1 | Light Green |
Car 2 | Dark Green |
Car 3 | Greenish |
Car 4 | Azure |
Car 5 | Other |
Car 6 | Blue |
I would like to create a slicer that can filter out different Green cars or different Blue cars for example.
Is there a way in powrebi to create custom filters on a slicer? I tried creating a measure but it doesnt seem to work on a slicer...
Something in this way
IF Column B = "Azure" or Column B ="Blue" THEN "Blue" (so on the slicer I have Blue option that will filter based on the conditions)
IF Column B="Light Green" or Columnb ="Greenish" .... THEN "Green" (so on the slicer I have green option that will filter based on provided conditions.)
Solved! Go to Solution.
You could create a calculated column as
Colour = SWITCH( TRUE(),
'Table'[Column B] IN { "Azure", "Blue" }, "Blue",
'Table'[Column B] IN { "Green", "Greenish" }, "Green"
)
and then use the new column for slicing and dicing.
You could create a calculated column as
Colour = SWITCH( TRUE(),
'Table'[Column B] IN { "Azure", "Blue" }, "Blue",
'Table'[Column B] IN { "Green", "Greenish" }, "Green"
)
and then use the new column for slicing and dicing.
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 |
---|---|
106 | |
104 | |
77 | |
68 | |
61 |
User | Count |
---|---|
144 | |
106 | |
106 | |
82 | |
70 |