cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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,

Garth

Helpful resources

Announcements
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)