Forum Discussion
Date X-Axis with different dates
Hi Power BI Community,
I got the following data as a example of the problem:
Date
| 29.04.2021 |
| 12.04.2021 |
| 28.05.2021 |
Created
| 29.04.2021 |
| 12.04.2021 |
| 28.05.2021 |
Completed
| 16.06.2021 |
| 14.06.2021 |
| 01.06.2021 |
I want to created a chart like this:
The chart should show the count of created and closed (each have diffenrent date stamp). The problem is the date x-axis.
Hi Anonymous,
You must create a calendar table and make inactive relationship with the date columns the use the function USERELATIONSHIP for your measures.
https://learning.xylos.com/en/learning/blog/power-bi-using-multiple-date-fields
1 Reply
Hi Anonymous,
You must create a calendar table and make inactive relationship with the date columns the use the function USERELATIONSHIP for your measures.
https://learning.xylos.com/en/learning/blog/power-bi-using-multiple-date-fields