How to filter data by icons in visual Cards

[Anonymous]

Dear All,

I have a dashboard like this

on the left are QI and PI names in our hospital. The next column is the target for each project and the current outcome of that project. I also made visual cards (next to the value column) to alert that project achieved or not achieved the target.

Now I want to make a filter based on alert icon on visual cards so that when I choose the filter the dashboard only displays projects that achieved target (projects that have green alert icons) or not achieved the targets (projects that have red alert icons) like following

I do not know how to create filter like that.

Could anybody here help me with that? Thank you very much.

[Anonymous]

Hi  @Anonymous ,

According to your case problem, you want to create a filter based on the alert icon on the visual card, so that when you select the filter, the dashboard only shows items that achieve the goal (items with green alert icon) or items that do not achieve the goal (items with red alert icon), can you disclose if it is convenient for you whether the items with different colored alerts are achieved through Measure by logically outputting the colored strings and placing them in "Conditional format" or how? 

My idea here is that you can create a new dimension table containing the "red, green" values to be placed in the Measure, and then create the Measure again by using the DAX function of Selectedvalue() to manually make logical judgments and filters for this visual by the color selected by the slicer.

SELECTEDVALUE function - DAX | Microsoft Learn

Best Regards,

Liu Yang

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

[Anonymous]

Hi @Anonymous 

I just give an example for project "Percentage of rejected specimens" as following:

The red icon on the rightmost corner is a Visual Card that I put a measure on it. The Measure as follows:

The Measure "CurrentValue" is as follows:

As you suggested, I should replace UNICHAR() with a value in a Dimension table, right?. If so, I do not know how to do it. Could you please guide me to do that?