cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
MartijnNL Member
Member

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.

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support Team
Community Support Team

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

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 REPLY 1
Highlighted
Community Support Team
Community Support Team

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

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.