conditional background formatting to table based on slicer selection

Hi Rasitha_PB 

If you build a relationship between Sales and Store table, you couldn't use conditional background formatting successuflly. Due to the relationship and slicer and table is used with same store field from store table, Power BI will make all selected judgment results return true. 

It is better for you to build an extra unrelated store table. Or you can remove the relationship between Stores and Sales table, then use Sales[Store] in table instead of Store[Store] and build a new measure to calculate the Sum Amount per Stores. Then you can use conditional formatting in table visual successfully.

Best Regards,

Rico Zhou

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