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) and format it as dashed (dotted/solid) line, it only stick with one month (see blue dot in below chart) and it doen't distribute it to all months (like red or orange line in above chart):

 

 

It is already added to line values:

 

Please help me to write next constant line into this chart

 

Thank you

Need Help

6 Replies

  • 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

  • parry2k's avatar
    parry2k
    Super User
    4 years ago

    krz_b SO you are saying if you are not using relative filtering it works but otherwise not. If that is the case, it doesn't make sense either because the constant line measure is a fixed value and relative date filtering shouldn't have anything to do with this. Can you share pbix file?

    • krz_b's avatar
      krz_b
      Frequent Visitor
      4 years ago

      Hello parry2k ,

       

      Do you have any news - please check your inbox, you shoud see the link to the file - I wasn't 100 sure whether this file doesn't contain any sensitive data

      Thanks a lot

  • parry2k's avatar
    parry2k
    Super User
    4 years ago

    krz_b that doesn't make sense, can you share pbix file, remove sensitive information before sharing.