Date hierarchy format not working in line and stacked column chart

[amnaanwer]

Hi everyone,

I am using a simple measure as column values and running total (quick measure) on line value in line and stacked column chart. Date is on shared axix displaying as January-2017 and February-2017 and so on. This shows me correct values of running total on line as shown below:

However, as soon i switched to the Date hierarchy on shared axis, so i can drill down from year to month and quarter. Then, Line values changed to same as the values on stack as shown below:

Can someone please tell what is the problem here? Does the line and stacked column chart visual supports date hierarchy or not? If not then how can i display my running total values on line as in first screenshot but using the date hierarchy?

Thanks in advance!

Regards,

Amna Anwer

[SivaMani]

@amnaanwer,

It's working fine for me. Could you plese share some sample data?

[amnaanwer]

Hi SivaMani

I am unable to attach pbix file here. I am sharing with you screenshots from my pbix file.

Screenshot-1:

Screenshot-2:

In this file, screenshot-1 shows i am using simple date format i.e 'Month' from CAC sheet on shared axis of line and stacked column chart and it is giving me correct results of running total on line values. But in Screenshot-2 you can see as soon i use the Date Heirarchy from 'Months' sheet, the chart will start showing incorrect results on line values. Kindly look into this.

Thanks!

[SivaMani]

@amnaanwer,

Got it. 

Cummulative CAC is quick measure. Right?

which fileds have used here to calculate Running total

[amnaanwer]

Yes, commulative CAC is a quick measure. And the formula for it is:

CAC - Cummulative =
CALCULATE(
SUM('CAC'[CAC]),
FILTER(
ALLSELECTED('CAC'[Month]),
ISONORAFTER('CAC'[Month], MAX('CAC'[Month]), DESC)
))

Base value here is a column CAC and field is 'Month' which is a date hierarchy in Months sheet.