topic Re: Filtering "Red" and "Green" in a project with Measures in DAX Commands and Tips

Filtering "Red" and "Green" in a project with Measures

Anonymous — Wed, 12 Jan 2022 08:48:37 GMT

I have a project created with Measures. Can we filter red and green with measure in a matrix?

To give more detail, i would like to filter the matrix in attached image by green or red.

Ie. if i filter green, Region C1-Z August value shouldnt be visible. On the other hand, rest of the green values in August column should be visible.

Another example ie. if i filter green Region C1-Y September value shouldnt be shown. But, rest of the green values in matrix including Region C1-Y August value should be visible. The rows containing any red value should not be deleted completely.

I hope its clear. Looking forward for your suggestions.

Re: Filtering "Red" and "Green" in a project with Measures

ValtteriN — Wed, 12 Jan 2022 08:55:01 GMT

Hi,

You could create a Filter measure with the same specifications as in the conditional formatting. E.g.

So here we can imagine that the condition for green is to have the year=2021. Now the visual displays the same values as this imaginary condition.

I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!

Re: Filtering "Red" and "Green" in a project with Measures

TOK — Sat, 15 Jan 2022 12:06:41 GMT

Hi Anonymous,

I found a video related to your problem. I hope it helps you to filter by the formatting measure

Re: Filtering "Red" and "Green" in a project with Measures

Anonymous — Thu, 27 Jan 2022 09:12:10 GMT

Hi Anonymous ,

May I ask how you set your colors? Please let me know.

Here's a similar post about filter data based on color, please refer to

Filter Data based on Color - Microsoft Power BI Community .

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.