Forum Discussion
show greater values with a numeric slicer
Hi elois33
I checked your sample file. It seems the measure is working. And I created a similar measure for weight. Both filter the matrix visual. Where did you think it is not working?
For the second question, you can set up conditional formatting for icons . Select Format style by Field value. You need to create a measure to compare the available lots with the targets or needs, which returns different colors for each scenario. And use this measure in "What field should we base this on?" box. For example,
Color measure =
IF (
SUM ( 'Table'[available amount] ) < SUM ( 'Table'[target amount] ),
"Red",
"Blue"
)
You can also use Format style by rules, here is an example. The measure should be different.
Conditional Formatting in a Matrix - Microsoft Power BI Community
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it. Highly appreciate your Kudos!