I have the following pbix file:
https://drive.google.com/file/d/10JmaeMYyHXXzxQ8_TJtcjliivs2SZL8X/view?usp=sharing
It's a simple sales data model, with dimensions of month and store. Two unique features of this report are that the Month axis in the main visual runs in reverse, and that the measures on this visual need to only display in the Time Range selected (but still show the entire time range in the axis of the visual). I have achieved this through a disconnected table, a measure that utilizes a switch, and "Show items with no data" on the shared axis.
I need to make the [Cumulative Total Sales] measure begin its running total at the minimum Month of the filter context (i.e., relative to Time Range selected), not at the minimum Month in the visual (which is always Jan 19). For example, for filter context:
Store Name = "A"
Time Range = "Last 6 Months"
the [Cumulative Total Sales] measure needs to start its running total at Apr 19, as that is where the first non-zero [Total Sales] is at, not at Jan 19 (which is the minimum of the chart).
Similar, for filter context:
Store Name = "C"
Time Range = "Last 3 Months"
the [Cumulative Total Sales] shouldn't be displayed at all, since it doesn't have any sales in the last 3 months.
How can I achieve this? I know that I need to do something to my __min_month variable in my [Cumulative Total Sales] measure, but I don't know what to do.
