Forum Discussion

krz_b's avatar
krz_b
Frequent Visitor
4 years ago

Add constant (dashed) line to combo chart

Hello,   I am trying to add next dahsed line contant line into combo chart (line and stacked column chart), same like it is in this picture:    After I add new measure (percentage format) a...
Need Help
parry2k's avatar
parry2k
Super User
4 years ago

krz_b what measure you used for constant line, it should be simply

 

Constant Line = 0.6

 

 

✨ Follow us on LinkedIn and  to our YouTube channel

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

 

⚡ Visit us at https://perytus.com, your one-stop shop for Power BI-related projects/training/consultancy.

krz_b's avatar
krz_b
Frequent Visitor
4 years ago

Hi parry2k,

Thank you for your answer, the measure was set like you described

It can be seen in the chart (see blue dot) but it cannot be distributted properly,

Thanks for you help

  • krz_b's avatar
    krz_b
    Frequent Visitor
    4 years ago

    Hi @parry2k,

    Thank you for your message, it looks like it is the issue with one measure which is included into CQD (Microsoft call dashboard data source) Query, called StartTime.

     

    Issue occurs when the filter type is changed to 'relative date' to show the data for last n-months.

     

    This filter is really nice because I do not have to manually change the month I want to report