Different constant lines in small multiples

[Ansisy]

Hello Experts,

I tried in many ways to add different constant lines in each quadrant of small multiples but I can't. It shows me both constant lines in all quadrans.

I want for KPI 1, 2, 3 to see only the 70% constant line and for KPI 4 to see only the 43% constant line.

Is such a thing possible?

Thank you!

[coom80]

The only solution i've found is to fix the axis and location and then draw a line on top at the relevant height. Not ideal, but if you have fied axes (0-100% for example) then the static line can be placed anywhere.

[rvs513]

This is misleading. This issue is NOT solved and there is no solution (yet).

[amitchandak · Accepted solution]

@Ansisy , I doubt that. I tried a measure in constant line and it does not check the values. It just take else value