Forum Discussion
Line and stacked column chart help
That looks much better. I tried making the same changes to my file and I'm not sure if I'm doing something wrong or am missing a step. I create a new table, selected mark as date table, created the week column. Then swapped out mytable.week to calendar.week. Then created a new column, called running total using mytable.client number and calendar.date (since I'm still using the other running total column). It's now showing the right number (no longer a 50-50 split) but it's showing the same numbers for every week.
Also, is there a way to change how the week is represented? Instead of 2020-4, have it state the day of the week (e.g. 2020-01-20, 2020-01-13, 2020-01-06, etc.)?
Most Valuable ProfessionalHi Anonymous ,
use this
Week = 'Calendar'[Date] - WEEKDAY('Calendar'[Date],2)+1I added a relative filter to limit the date range.
Regards,
Marcus
Dortmund - Germany
If I answered your question, please mark my post as solution, this will also help others.
Please give Kudos for support.
That did it, but uncovered a different issue. Compared to my original file, the dates are wrong. My data has items starting at 17-04-24 through 19-09-30, however the chart now says the last item is from December.
Added screenshot with names blurred out. It should show running total for all columns, and Nov and Dec should say Aug and Sept, the real dates the data is from.
Also, any thoughts on why the columns are showing the total values instead of a running total like the sample pbix?
- mwegener
Hi Anonymous ,
a date table always includes an entire year.
You must explicitly filter the date table for the desired period.
So I used your sample, where it was working with stacked columns and a running total, and simply added the real data and swapped out the column values and column series (w/o editing or removing any of your changes) and I still have the issue where all columns display the same total, instead of a running total for that week.