Forum Discussion

Worlock's avatar
Worlock
New Member
6 years ago

Merge date into graph with correct dates

Hi all,   Im totally new to Power BI, and just playing arround with it. My use case is this: Whenever I fill up my car at the gas station, I note the amound of KM's I drove. Together with the lite...
Need Help
v-lionel-msft's avatar
v-lionel-msft
Community Support
6 years ago

Hi Worlock ,

 

The reason your chart looks like this is because the Axis don't match the Values.

If you have two tables, they represent gasoline consumption and weather.

You can use the date columns in the two tables to create relationships, and then use any of the date columns to create visualizations.

(Also, make sure both date columns are in date type.)

 

Best regards,
Lionel Chen

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

Worlock's avatar
Worlock
New Member
6 years ago

So. do I need to create 2 tables and then a relationship? Or within 1 table?
Also, I can't specify a data type, it's greyed out.

  • v-lionel-msft's avatar
    v-lionel-msft
    Community Support
    6 years ago

    Hi Worlock ,

     

    I don't know much about your data model, please show me a sample data model.

     

    Best regards,
    Lionel Chen

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