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 different target for each month.
apoligies if this has already been posted,
Atanas
4 Replies
- amitchandak
Super User
Anonymous
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?
