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.
1 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.
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.
