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! It's time to submit your entry. Live now!
Hi all,
I made a table but the dates won't be shown correctly in terms of position.
as you can see above, one project is being shown in 4 lines. how can I make it one line showing dates in front of the project name?
Thanks for your help
@Anonymous you have multiple options, one would be to unpivot your data so that the different timestamps are listed in the same column (DateTime) with a new column for the type of the timestamp (Milestone)
ProjectName Milestone DateTime
You'll then also need to provide a helper column with the desired sort order of your milestones (by default they are sorted alphabetically)
| User | Count |
|---|---|
| 3 | |
| 3 | |
| 2 | |
| 2 | |
| 1 |
| User | Count |
|---|---|
| 5 | |
| 3 | |
| 1 | |
| 1 | |
| 1 |