Create a RAG Colour Slider

[Anonymous]

I have two columns A and B as shown in table. Need to have three colour slicers, Red, Amber, Green with min and max value so that based on the slicer and values input by user, the background colour of column A would change. All the slicers show the value range of column B. How can I achieve this?

[Anonymous]

Hi Yang,

Thanks for your response but this is not my requirement. 

The requirement is to have colour slicers, so whatever range of B is selected on the Green/ Red/ Amber slicer, for those values corresponding data in column A with be coloured. Please help with this.

Many thanks,

Prear

[Anonymous]

Hi @Anonymous ,

Drag columns A and B to the table visual object, select the drop-down arrow next to A, and choose Conditional formatting.

Set it up like the screenshot below.

Drag column B into the Slicer visual object.

The final page result is shown below.

The pbix file is attached.

If you have any other questions please feel free to contact me.

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!