Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Time Series Chart With Different Goal For Each Month

Hello Dear Community,    Can someone help me understand if it is possible to create a chart like the one here in Power BI? My main concern is with regards to the red line, that indicates a differe...
Need Help
Show and Tell
Tutorial Requests
Anonymous's avatar
Anonymous
Not applicable
6 years ago

amitchandak 

 

Thank you for your swift reply!

 

would you please clarify a bit? Should this be a calculated column? 

you're correct summing my data is based on monthly distribution and I understand which chart to use, but cannot understand how to assign the goal for each month.

 

all due respect,

 

Atanas

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

Anonymous , You already have goal for each month or do want to define it using DAX?

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    amitchandak ,

     

    I already have it, it is on the bottom of the table, below the graph. the red lines visually represents it.

     

    Please let me know if you need some more information.

     

    Thank you,

     

    Atanas