Shade the Area Between Two Lines

#1

Hello Community,
I have a line chart with date range on the X-axis in monthly intervals and the Y-axis has two lines. Line 1 is a count measure of current year transactions (labeled Current Count) and line 2 is count measure last year’s transaction count (Labeled Last Year) using the Add Period Over Period comparison.

I want display the difference of the 2 measures as a shaded area. Similar to yellowish area in the attached picture. Only online references are to excel but the directions have quite translated to Dundas. Any help is appreciated!
Shaded%20area%20example

#2

Hey Everardo,

It looks like a Range Chart might be what you’re looking for. You’ll be able to set 1 measure as the Range Start and the other as the Range End. The application will automatically fill the difference between the two measures.

Thanks,
Mark

2 Likes
#3

Thank you @mark.barciak this worked perfectly