Power BI - How to show two times/dates on x-axis on clustered column visual.

[AshishTabade]

Hi, I have a data as below

ID	Opened Date	Closed Date
ABC123	1/04/2025	7/04/2025
PQR123	24/03/2025	7/04/2025
XYZ123	31/03/2025	7/04/2025

How can I show the ID in clustered column where one column represent "Opened date" and other as "Closed Date"

I need a visual like below - Blue column - Opened Date and Green column - closed date

Y-axis has ID

Can you please let me know how is this possible as I can only take one date on x axis and the relationship i have doesnt allow 2 dates.

[v-kpoloju-msft · Accepted solution]

Hi @AshishTabade,
Thank you for reaching out to the Microsoft fabric community forum. Thank you @lbendlin, for your inputs on this issue.

After thoroughly reviewing the details you provided, I was able to reproduce the scenario, and it worked on my end. I have used it as sample data on my end and successfully implemented it.

I took sample data my end below mentioned:

Then, unpivot the Date Columns. Select the Opened Date and Closed Date columns (hold CTRL to multi-select). Right-click and choose Unpivot Columns. Table looks like this below:

Rename “Attribute” to Date Type, and “Value” to something like Event Date if needed.

Go back to Power BI Report view. Add a Clustered Column Chart. Set up the chart like this: X-Axis: Event Date (or a month/year hierarchy if desired) Legend: Date Type (this will split Opened vs Closed into two colors/bars) Values: Use ID.

Output looks like below:

Also please refer to the below document for better understanding:
Customize X-axis and Y-axis properties - Power BI | Microsoft Learn

If this post helps, then please give us ‘Kudos’ and consider Accept it as a solution to help the other members find it more quickly.

Thank you for using Microsoft Community Forum.

[AshishTabade]

Thanks @v-kpoloju-msft for the details. It worked.

[lbendlin]

The DAX function you are looking for is USERELATIONSHIP.

Please provide sample data that fully covers your issue - including Y axis values.
Please show the expected outcome based on the sample data you provided.