Forum Discussion
line chart - average measure
Hi,
I have table with columns (Final destination and Average PTO) and I need to create line chart where: x-axis will be DATE and y-axis will be AVERAGE PTO.
Thank you
Ondřej
3 Replies
Fidzi8 , Do need avg to time. You simply can not have it, you have to convert it min/sec and use it
refer these as per need
https://radacad.com/calculate-duration-in-days-hours-minutes-and-seconds-dynamically-in-power-bi-using-dax
https://social.technet.microsoft.com/wiki/contents/articles/33644.powerbi-aggregating-durationtime-in-dax.aspx
https://www.pbiusergroup.com/communities/community-home/digestviewer/viewthread?GroupId=547&MessageKey=814a2cb4-3cca-4cd1-a620-c467adeaaaf6&CommunityKey=b35c8468-2fd8-4e1a-8429-322c39fe7110&tab=digestviewer
https://community.powerbi.com/t5/Quick-Measures-Gallery/Chelsie-Eiden-s-Duration/m-p/793639#M389Hi amitchandak ,
I created duration column.But I donť need to use for the value. This duration I can use it to x-axis.
Thank you
OndřejHi Fidzi8 ,
So you want the duration to be the X-axis not the date?
And you have solved your issue?
Best Regards,
KellyDid I answer your question? Mark my post as a solution!
