Forum Discussion

_Ester_'s avatar
_Ester_
Icon for Helper I rankHelper I
2 years ago
Solved

Issue with Date and Sales Visualization in Power BI

Hello all!

I am experiencing an issue with visualizing my sales data over time using Power BI Desktop. When I try to include the date and the column with the expenditure per single order, I am unable to display this data, for example, in a line chart.

The date table is created using the CALENDARAUTO(12) formula.

You can find two sample files and the PBIX file with the data already loaded here:
https://drive.google.com/drive/folders/1SabsEKqw5ERx9ipk7tRe61xko5Yog02K?usp=sharing

What could be causing this problem? What am I doing wrong?

Thank you!

  • The relationship is not finding any matches.

    paid_date has date/time that doesn't match with the Dates table because of the time portion.

    Possible solution : remove the time portion and make both fields date only.

     

2 Replies

  • HotChilli's avatar
    HotChilli
    Icon for Community Champion rankCommunity Champion

    The relationship is not finding any matches.

    paid_date has date/time that doesn't match with the Dates table because of the time portion.

    Possible solution : remove the time portion and make both fields date only.