topic Re: Plot 2 date columns in Line Chart in Desktop

Plot 2 date columns in Line Chart

Anonymous — Wed, 15 Dec 2021 21:40:56 GMT

Hello Power BI comrades,

I wish to plot 2 date columns on the same x-axis of a Line Chart. Both columns have the MM-DD-YYYY format and I have tried to put either of the two date columns on the Axis and clicked on "show items with no data" but that only really reflects only the data of one date column at a time.

Can you please give any hint on how I should solve this? I am quite new to DAX syntax but I will try whatever you suggest.

Re: Plot 2 date columns in Line Chart

Anonymous — Thu, 16 Dec 2021 02:04:56 GMT

HI Anonymous

If you plot two columns on X - axis how willt the graph know which direction to follow for aggregation date1 or Date2.

What you can do is have a drill down on the graph so that you can drill at whichever date level you need the grapf to show and then drill back up again.

Re: Plot 2 date columns in Line Chart

Anonymous — Thu, 16 Dec 2021 08:39:27 GMT

Hi Anonymous ,

Many thanks for your reply!

Basically I wish to plot those 2 date columns on an x-axis that represents months (from Jan to Dec) even with null data. I just dont know how to include the months (maybe via another table?) and include it in my chart. The idea is to provide a comparison of the 2 date columns on a monthly basis on the same chart. 🙂

Re: Plot 2 date columns in Line Chart

Anonymous — Mon, 20 Dec 2021 09:05:56 GMT

Hi Anonymous

I found a similar issue , it mentioned using USERELATIONSHIP DAX to deal with . You can refer to it .

https://community.powerbi.com/t5/Desktop/How-to-add-data-on-a-linear-graph-by-two-date/m-p/408805

Best Regard

Community Support Team _ Ailsa Tao

Re: Plot 2 date columns in Line Chart

Anonymous — Wed, 05 Jan 2022 06:22:51 GMT

Hi Anonymous

Has your problem been solved ? If it has been solved, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regard

Community Support Team _ Ailsa Tao