Forum Discussion
Constant Line in column chart does not work with measure using ISINSCOPE
Hi cosmicyes ,
I don't mean for you to create a fixed line value. I just want to explain why the line always stays on 0, because constant line can't tell which level the X-axis is at. So, Line and stack column chart maybe the only way you can do it.
Best Regards,
Community Support Team _ kalyjIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi cosmicyes ,
Because for constant line, it can't tell which level the X-axis is at. If you add a ELSE value in the SWITCH formula, it can return that value like below.
Best Regards,
Community Support Team _ kalyj
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Dear v-yanjiang-msft ,
thank you for your input.
But this way I always have the same constant line, no matter if week, month or whatever is selected. This is unfortunately not what I need.Hi cosmicyes ,
I don't mean for you to create a fixed line value. I just want to explain why the line always stays on 0, because constant line can't tell which level the X-axis is at. So, Line and stack column chart maybe the only way you can do it.
Best Regards,
Community Support Team _ kalyjIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi v-yanjiang-msft
ah, I see. There was some misunderstanding on my side 🙂
Thank you for your very quick reply and please excuse that it took me so long to reply on your first post.
