Interactive Item on Dashboard

Hi Anonymous ,

We can create a color table and three color measure to meet your requirement.

1. Create a color table that contains red, green and yellow.

2. Create three measures and configure each field’s background.

Green measure = 
var selected_color = SELECTEDVALUE('Table (2)'[Color])
return 
IF(ISBLANK(selected_color),"Green",IF(selected_color in {"Green"},"Green",BLANK()))

Red Measure = 
var selected_color = SELECTEDVALUE('Table (2)'[Color])
return 
IF(ISBLANK(selected_color),"Red",IF(selected_color in {"Red"},"Red",BLANK()))

Yellow measure = 
var selected_color = SELECTEDVALUE('Table (2)'[Color])
return 
IF(ISBLANK(selected_color),"Yellow",IF(selected_color in {"Yellow"},"Yellow",BLANK()))

3. At last we can get the result like this,

If it doesn’t meet your requirement, could you please show the exact expected result based on the table that we have shared?

BTW, pbix as attached.

Best regards,

Community Support Team _ zhenbw

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

Anonymous no clue what is the question, please elaborate. 

Anonymous , The information you have provided is not making the problem clear to me. Can you please explain with an example.

you can create a table using enter data and have slicer on that.

Refer to these steps : https://community.powerbi.com/t5/Desktop/Slicer-MTD-QTD-YTD-to-filter-dates-using-the-slicer/td-p/500115