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!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount 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 |
---|---|
5 | |
3 | |
3 | |
2 | |
2 |
User | Count |
---|---|
9 | |
3 | |
3 | |
2 | |
2 |