Creating a column chart with 2 different dates on the same axis

[Su_Alm]

Hello,

I'm seeking guidance on how to create a clustered column chart on power bi where two date columns from the same table are displayed on a the same axis.

In my data, I have two date columns and a column for the amount, I want to create a clusterd column chart with the date being the x axis, and the amount for each date column as the y axis.

Start Date	Resolution Date	Amount
7/10/2023	9/9/2023	100
9/9/2023	10/5/2023	500
8/10/2023		1000
8/9/2023		1500
8/10/2023	10/25/2023	2000

Once more, I would like to emphasize that the amount should be visually presented using two columns in the chart: "amount(start)" and "amount(resolution)". The x-axis should be structured based on months.

[amitchandak · Accepted solution]

@Su_Alm , Refer similar example and file, how to deal with it

Power BI: HR Analytics - Employees as on Date : https://youtu.be/e6Y-l_JtCq4
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...
Power BI HR Active Employee Tenure Bucketing, and Hired, Terminated, and Active employees: https://youtu.be/fvgcx8QLqZU

[v-yangliu-msft · Accepted solution]

Hi  @Su_Alm ,

Here are the steps you can follow：

1. Select [Start Date] and [Resolution Date] – Unpivot Columns.

Note:

When using Unpivot Columns, the selected columns with null values will be automatically ignored when converting, if you want to keep the null values, you can select two columns and replace the null values with other dates.  Transform - Replace Value.

2. Result:

Best Regards,

Liu Yang

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

[amitchandak · Accepted solution]

@Su_Alm , Refer similar example and file, how to deal with it

Power BI: HR Analytics - Employees as on Date : https://youtu.be/e6Y-l_JtCq4
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...
Power BI HR Active Employee Tenure Bucketing, and Hired, Terminated, and Active employees: https://youtu.be/fvgcx8QLqZU