Little bit complicated workaround is needed.
Calculate avg by customer x month
And change filters to context for LOD work under filtered.
Prepare placeholder as 1
We cannot control "Null"'s cell, so approach from opposite side.
Change everything to yellow and add colors to non-null cells (white and orange).
Create bar graph
Put color and hide g.total
I am not completely clear on the color logic, so changed it slightly to show as below.
Added the date filter to context and created the below 2 calculated fields.
Hope this helps.
Spend Trend Sample.twbx 1.1 MB
Perfect! Thank you, Shin.