filter in a shape needed.

[ROG]

Hey guys,

I have some shapes which I use as traffic lights based on the variance, and one them needs to be filtered for a specific channel. Since it's not possible to add a filter to a shape, what would be my option? Note: I cannot add filter to the page as it would make others visuals wrong.

Thanks in advance.

[ROG · Accepted solution]

Hi all, I figured out a way to add a filter with a pai chart. You just need to create 3 metrics based on RAG.

1st metric with a logic to glad number below the target. RED

KPI colourR TopUps = IF([KPI Var TopUps] <-0.05, 1,0)

2nd logic to flag numbers on the target AMBER

KPI colourA TopUps = IF([KPI Var TopUps]>=-0.1 &&[KPI Var TopUps] <0 ,1,0)

3rd logis is for numbers greater than zero. Which would be GREEN.

Once you have these thre metrics, you can add them to the slicers in the PIE chart, and add the respective colours.