Forum Discussion

benjamincoady's avatar
benjamincoady
Helper 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
Community 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.

 

benjamincoady's avatar
benjamincoady
Helper I
6 years ago

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