- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Date hierarchy format not working in line and stacked column chart
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Got it.
Cummulative CAC is quick measure. Right?
which fileds have used here to calculate Running total
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.

Helpful resources
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Power BI Monthly Update - February 2025
Check out the February 2025 Power BI update to learn about new features.

Subject | Author | Posted | |
---|---|---|---|
12-03-2023 07:46 PM | |||
08-09-2024 01:24 AM | |||
08-08-2024 10:34 PM | |||
Anonymous
| 06-10-2024 01:36 AM | ||
07-19-2024 09:48 AM |
User | Count |
---|---|
90 | |
82 | |
57 | |
41 | |
39 |