Clustered Column and Line Chart - Conditional formatting

Hello Community –

I am working on a line and clustered column chart. I have 7 tables – 1 table called ENTITY with various financial calculations; a comparative group (Metropolitan, Micropolitan, Rural) and year. The 6 linked tables contain benchmark financial data by year and have a corresponding comparative group (2 tables for Metropolitan, 2 tables for Micropolitan, 2 tables for Rural). I also have a slicer to select an entity. I have all 6 benchmarks as lines and one financial indicator from the Entity table as the column.

All 6 benchmark lines are making the visualization too cluttered and I would like to only show the related comparative group benchmark. I don’t want to add another slicer to filter by comparative group as the user may not know what comparative group corresponds to the entity. I have looked at the data colors on the format tab and don’t see a way to use a conditional format.

Any suggestions on how to solve?

Thanks!