Forum Discussion
hidzirf
Helper I
Helper IDuration value in line chart
Dear Expert,
I need help.
I have a Duration value in seconds. To be able to have in Days, hours and minutes format i have created a new column with below calculation
var vSeconds=[Duration]
var vMinutes=int( vSeconds/60)
var vRemainingSeconds=MOD(vSeconds, 60)
var vHours=INT(vMinutes/60)
var vRemainingMinutes=MOD(vMinutes,60)
var vDays=INT(vHours/24)
var vRemainingHours=MOD(vHours,24)
return
vDays&" Days "&
vRemainingHours&" Hours "&
vRemainingMinutes&" Minutes "&
vRemainingSeconds& " Seconds"
But now I want to shows the newDuration in Line chart but i cant do so as the Data Type is Text and it will only count the rows if i put it in the Value. i would like to be able to shows the line chart as below:
Please help how can i achive this. Thank you.
2 Replies
- TheoC
Community Champion
Hi hidzirf
I don't believe this is possible at this point in time. There are several ideas that are similar but not yet implemented.
Can you take a look at this link as it may be helpful as a workaround: https://community.powerbi.com/t5/Desktop/Alternate-Measure-for-Data-Labels-in-a-Column-Chart/m-p/1145147#M519638
All the best,
Theo
v-kkf-msftCommunity Support
Hi hidzirf ,
This feature is currently unsupported, please submit your ideas here.
https://ideas.powerbi.com/ideas/
Best Regards,
Winniz
