Reply
Member
Posts: 58
Registered: ‎08-07-2018
Accepted Solution

Measure to show sum as constant line for every month

Hello,

 

I want a graph to show a line that shows the sum of all months as a constant line, so not the value of the month on the x-axis, but the sum:lemtpfy1.PNG

 

The current measure for the orange line is: 

CALCULATE (SUM([Amount]); ALL('Calendar'[month]))

 

but the value calculated with 'sum([Amount]) should be presented as a constant horizontal line.


Accepted Solutions
Highlighted
Community Support Team
Posts: 5,394
Registered: ‎09-21-2016

Re: Measure to show sum as constant line for every month

Hi @MartijnNL,

 

Make sure there existing a relationship between Calendar table and data table which contains amount values. Please drag [month] field from 'Calendar' table onto X-axis of chart.

 

Best regards,

Yuliana Gu

View solution in original post


All Replies
Highlighted
Community Support Team
Posts: 5,394
Registered: ‎09-21-2016

Re: Measure to show sum as constant line for every month

Hi @MartijnNL,

 

Make sure there existing a relationship between Calendar table and data table which contains amount values. Please drag [month] field from 'Calendar' table onto X-axis of chart.

 

Best regards,

Yuliana Gu