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
Hey,
By making a line graph I have some difficulties by ranking my dates in chronological order.
How can I solve this problem? I have this with all of my Line Graph i'm making.
Thanks in advance!
Solved! Go to Solution.
HI
In the Datamodel just you add custom column
DateKey = ([Year]*10000)+([Month Nbr]*100)+[DayOfMonth])
Then go to your report designer and select datecolumn and choose sortby and select DateKey
Hope this will work
Generate Datekey and select your date column and sort by Datekey it will order your date
HI
In the Datamodel just you add custom column
DateKey = ([Year]*10000)+([Month Nbr]*100)+[DayOfMonth])
Then go to your report designer and select datecolumn and choose sortby and select DateKey
Hope this will work
Hi,
Is there a possibility that you can make it for me?
Because I really don't understand what I need to do.
Thanks in advance
Hi,
Thanks for all the help!
Please make this status resolved like my answer if it works for you happy to share knowledge !!!!!!
You need to convert the data type from text to date/time.
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 38 | |
| 38 | |
| 36 | |
| 28 | |
| 28 |
| User | Count |
|---|---|
| 124 | |
| 88 | |
| 74 | |
| 66 | |
| 65 |