Showing results for 
Search instead for 
Did you mean: 
gazoller Frequent Visitor
Frequent Visitor

Bar and Line Chart Recommendation

I'd like to use a bar & line chart where sales over time are the bars and the lines are a calculated measure rather than a constant value that I type in.


Here's where I'm stuck... I would like the line measure values to be calculated as aggregates and displayed as a straight line across whatever time period is selected (e.g. if Years, the calculated line is the aggr for all years displayed). Currently, if I add my calcuated field the calculation is happening for each bar, resulting in a jagged line (up & down across each data point).


Any recommendation on how to create the line measures so they calculate an aggregate for all periods in the report - resulting in a straight line?


Thank you,


Helpful resources

New Topics Started Badges Coming

New Topics Started Badges Coming

We're releasing new versions of the badge that everyone's talking about. ;) Check your inbox for notifications.

MBAS 2020

Save the new date (and location)!

Our business applications community is growing—so we needed a different venue, resulting in a new date and location. See you there!

Difinity Conference

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Kudoed Authors (Last 30 Days)