Forum Discussion
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...
amitchandak
Super User
Super UserAnonymous
You can have a goal in the table, join the same time dimension. In case data is at the month level. Use the month start date.
You can use line and clustered chart.
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
Anonymous , You already have goal for each month or do want to define it using DAX?
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