The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now
Hi,
Is there a way to filter the data on the basis of the color ? I have a data table where i have done conditional formatting to show Red,Green,Yellow. I want to know if there is a way to add a slicer where i can filter on the data which is red,green etc.
Thank you for all the help in advance.
Hi saknivi
You also could create a calculated column to achieve this goal
Column = IF ( colorslicer[amount] >= 0 && colorslicer[amount] < 7, "Red", IF ( colorslicer[amount] >= 7 && colorslicer[amount] < 12, "Blue", IF ( colorslicer[amount] >= 12, "Yellow", "White" ) ) )
Best Regards,
Zoe Zhi
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
So here's the issue i have :
The value in my rule always keeps changing and the basis of the value i have added color coding in my data, thus i am not sure how to go about this now?
Hi saknivi,
Did you mean that after you set conditional color, you want to data automatically changed by slicer without writing measure or calculate column for slicer, right? If so, I think your requirement can't be achieved currently, you need to write corresponding measure or calculated column for slicer which match conditional formatting.
Best Regards,
Zoe Zhi
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi saknivi,
In your scenario, if you want to filter data based on color, you could try below steps:
1.Create a color table(used for slicer)
2.Then you could try to use below measure
Measure 4 = VAR temp = IF ( MIN ( colorslicer[amount] ) >= 0 && MIN ( colorslicer[amount] ) < 7, "Red", IF ( MIN ( colorslicer[amount] ) >= 7 && MIN ( colorslicer[amount] ) < 12, "Blue", IF ( MIN ( colorslicer[amount] ) >= 12, "Yellow", "White" ) ) ) RETURN IF ( temp IN VALUES ( color[Column1] ), CALCULATE ( SUM ( colorslicer[amount] ) ), BLANK () )
3.Then you could set measure like below in Filters, and set conditional format for measure
Best Regards,
Zoe Zhi
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi saknivi,
In your scenario, if you want to filter data based on color, you could try below steps:
1.Create a color table(used for slicer)
2.Then you could try to use below measure
Measure 4 = VAR temp = IF ( MIN ( colorslicer[amount] ) >= 0 && MIN ( colorslicer[amount] ) < 7, "Red", IF ( MIN ( colorslicer[amount] ) >= 7 && MIN ( colorslicer[amount] ) < 12, "Blue", IF ( MIN ( colorslicer[amount] ) >= 12, "Yellow", "White" ) ) ) RETURN IF ( temp IN VALUES ( color[Column1] ), CALCULATE ( SUM ( colorslicer[amount] ) ), BLANK () )
3.Then you could set measure like below in Filters, and set conditional format for measure
Or you also could try to create a calculate column which is same as condition format like below, then use this column in Slicer
Column = IF ( colorslicer[amount] >= 0 && colorslicer[amount] < 7, "Red", IF ( colorslicer[amount] >= 7 && colorslicer[amount] < 12, "Blue", IF ( colorslicer[amount] >= 12, "Yellow", "White" ) ) )
Best Regards,
Zoe Zhi
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.
User | Count |
---|---|
158 | |
108 | |
96 | |
83 | |
75 |
User | Count |
---|---|
154 | |
137 | |
131 | |
81 | |
62 |