Forum Discussion
Helper ICan't stack two series column chart... need some help
Super Userutnapishtem , there two measures are from the same table? if not are those tables using a common date table?
In this case, both measures should finally refer to a common date table
To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :radacad sqlbi My Video Series Appreciate your Kudos.
Helper IHmm; I thought I replied, but looks like my reply got lost...
Anyway, I spent some time reading the articles you posted about creating a date calendar. I don't see why that is necessary here. I'm not trying to create different date slices or anything. I'm just trying to plot two different time series as stacked columns. Maybe I'm not understanding what PowerBI is doing with my data here. How would it know the relation between the data I'm plotting and the date it is on? I mean, it's not like the row numbers line up 1:1 with some arbitrary date. You're telling me both 'measures' (they're columns) need to 'use' a common date table. What does that even mean? The data is coming from Excel. Each column comes from a different table in Excel. Each table has it's own date column. Is that not possible to combine in PowerBI? I created a repro project that illustrates my problem, but can't find any place to upload it here, so it's on my OneDrive shared here: https://1drv.ms/u/s!BA7jl24SA2VzhbF00Rer7BXH3eGyvg?e=E1lqln