Forum Discussion
newpbiuser01
3 years agoHelper V
Cumulative Sum Line Chart Split by Legend
Hello, I have a data table which shows spend by year and month. I am trying to create a line cumulative line chart that will show the spend as it goes up over time. The data tables are as fo...
Mkarwa-123
3 years agoResolver II
newpbiuser01 It should be date-month-year for date table. you try just make as date in both tables make a relationship on date column and your filters will be working hopefully.
newpbiuser01
3 years agoHelper V
Hi Mkarwa-123 , I did that, I added the date(the 1st of each month) in the date table, and the spend table. Created a relaltionship between the two, but run into same issue. 😞