- 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
How to display data in clustered column chart - when working with date data
I'm a bit stuck, with something that feels should be quite simple - so I hope somebody can help me with this.
Basically I've got a table with sales data statistics:
ProductId, SalesDate and GrossSalesValue
This table holds data for a few years and I need to present side by side performance this year vs last year.
In Excel creating such a chart is very simple (see screenshot at the end of this post). I see that it takes two columns - one for 2016. year and second for 2017. year. But my table holds one field for GrossSalesValue and other for dates. Can I get from such a table clustered column chart to compare year data side by side? Can I achieve this with measures and DAX? I've tried TOTALYTD and Calculate(...; SamePeriodLastYear), but it didn't work
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Do you have a Calendar table?
If you do place the date on the axis and keep only the month from the resulting Hierarchy,
then drag the date field again but this time to the legend and keep only the year.
If no Calendar just break your date field into Month and Year columns and use those...
Place Month on the Axis, Year in the Legend and sales in the Values
Good Luck!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi @prokurors,
As Sean suggested, I could get the chart output like below. In my test, I didn't use calendar table, just select Month from date hierarchy as Axis, and select Year from date hierarchy as legend.
Best regards,
Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi @prokurors,
As Sean suggested, I could get the chart output like below. In my test, I didn't use calendar table, just select Month from date hierarchy as Axis, and select Year from date hierarchy as legend.
Best regards,
Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Do you have a Calendar table?
If you do place the date on the axis and keep only the month from the resulting Hierarchy,
then drag the date field again but this time to the legend and keep only the year.
If no Calendar just break your date field into Month and Year columns and use those...
Place Month on the Axis, Year in the Legend and sales in the Values
Good Luck!

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
08-09-2024 01:24 AM | |||
08-08-2024 10:34 PM | |||
06-08-2023 08:09 AM | |||
Anonymous
| 11-15-2023 08:16 AM | ||
02-21-2024 07:04 AM |
User | Count |
---|---|
141 | |
117 | |
80 | |
65 | |
47 |