Forum Discussion
Dates Field from Different Data Sources Not Separating
All sorted, needed to brush up on my Star Schema and create primary keys between the data tables. For anyone looking to work with data sets within the same dashboard, Ralph Kimballs Dimensional Modelling Techniques book is fantastic and goes through this topic comprehensively.
Thanks for everyones reply!
Hi benjamincoady,
In your scenario, I guess that you want to use measures from two tables in the same chart, but I don't know what style you want to show in x-axis? So if possible, could you please inform me in details?
Best Regards,
Zoe Zhi
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Zoe,
That's correct, yes. I'd like to show measures from two tables in one graph chart.
On the X-axis, I'd like the date when the survey was completed, there is one date only for each table. I am trying to show 2 dates, therefore creating two seperate columns, not one conjoined column which it is doing at the moment.
Any idea?
Thanks
Anyone?
Hi benjamincoady,
If you want to use two measure from different table, I think you need to use same date axis(you could create a calendar table, then use this date in axis), which should work.
Best Regards,
Zoe ZhiIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.