Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
98 | |
97 | |
81 | |
77 | |
66 |
User | Count |
---|---|
126 | |
105 | |
103 | |
81 | |
72 |