Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
I am trying to create a line chart visual with status date on the X axis and status number on the Y axiz but can't use the measure index or date fields in the X axis.
This is related to a process going through different stages with an estimated duration known for each stage.
This all works in a table but I can seem to use the ProjectedStatusDate in a line chart visual. I can't drop the field in the field box.
@btfergie
Please conver the [ProjectStatusDate] to date data type using power query.
Thank you but it does seem to be date type.
I don't beleive it is text date type. But if it was would you suggest usaing the format function?
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 19 | |
| 13 | |
| 8 | |
| 4 | |
| 4 |
| User | Count |
|---|---|
| 29 | |
| 19 | |
| 18 | |
| 11 | |
| 10 |