Forum Discussion

cosmicyes's avatar
cosmicyes
Helper II
3 years ago
Solved

Constant Line in column chart does not work with measure using ISINSCOPE

I thought this would be easy but it isn´t 😉   I have a stacked column chart where you can drill up and down from date / week / month / year. What I need is a constant line for showing a goal depe...
Need Help
  • v-yanjiang-msft's avatar
    v-yanjiang-msft
    3 years ago

    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 _ kalyj

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

v-yanjiang-msft's avatar
v-yanjiang-msft
Community Support
3 years ago

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 _ kalyj

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

cosmicyes's avatar
cosmicyes
Helper II
3 years ago

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.