Forum Discussion

benjamincoady's avatar
benjamincoady
Icon for Helper I rankHelper I
6 years ago
Solved

Dates Field from Different Data Sources Not Separating

Hi,    I am trying to bring in 2 different datasets, they are similar but have their differences. I am trying to create a bar chart showing the sum of "Happy Scores" against the date when the surve...
Need Help
  • benjamincoady's avatar
    benjamincoady
    6 years ago

    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! 

dax's avatar
dax
Icon for Community Support rankCommunity Support
6 years ago

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.

 

  • dax's avatar
    dax
    Icon for Community Support rankCommunity Support
    6 years ago

    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 Zhi

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.