Show data by month without accumulated total

[Anonymous]

Hi in the chart below, I am connecting to a query that has 3 years of data and the shorter darker portion of the chart shows the total in a month, and the lighter longer portion is the total all time.  I just want to show the monthly portion and use a slicer to select the year and month.  I am not able to figure out how to show just this.  My apologies if this has been asked before, I wasn't able to find what I was looking for.  Thanks in advance.

[v-frfei-msft · Accepted solution]

 Hi @Anonymous ,

To create a measure as below and create a bar chart.

Measure = CALCULATE(SUM(vunits[UNITS]),ALLEXCEPT(vunits,vunits[CITY]))-SUM(vunits[UNITS])

Pbix as attached.

[v-frfei-msft]

Hi @Anonymous ,

Could you please share your sample data and excepted result to me if you don't have any Confidential Information.Please upload your files to One Drive and share the link here.

[Anonymous]

@v-frfei-msft

[Anonymous]

Hi frfei, 

I've attached some sample data.  I want to aggregate it by month and display in a bar chart.  Using the play axis slicer I would like to play through each month and see the total of each month only.  Instead what I am seeing when I use the play slicer is the total all time stacked on top of total for month.  So the length on the total all time remains static and the inner bar showing the month to month aggregate changes over time.  I would like to see only the monthly data and remove the all time data portion.

sample data