Forum Discussion

UmairKamal's avatar
UmairKamal
Icon for Helper I rankHelper I
2 years ago

Measure not display in chart

Dear Users,   The measure I have is the total time spent by a person doing a task. and this works fine in a table however, it does not work in any graphs. I understand that this is because the meas...
Need Help
Show and Tell
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi UmairKamal ,
Here some steps that I want to share, you can check them if they suitable for your requirement.
Here is my test data:

Using the format function does force a conversion to text formatting.However only digital format displays are accepted on most visual objects. With this in mind, we can use the dynamic format of measure.
First, ensure that the options in the preview feature are turned on

Create a measure

 

 

Measure = HOUR(SELECTEDVALUE('Table'[Time]))*10000+MINUTE(SELECTEDVALUE('Table'[Time]))*100+SECOND(SELECTEDVALUE('Table'[Time]))

 

 

Ensure that the y-axis diapaly units option is none

 
Final output

Best regards,
Albert He

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

UmairKamal's avatar
UmairKamal
Icon for Helper I rankHelper I
2 years ago

Anonymous thanks for your reply. I have followed the steps as you mention but I am not getting the results. In fact, this measure is not even visible in the Matrix Visual. 

 

Total Time 10 = HOUR(SELECTEDVALUE('Report'[Time Spent (hh:mm:ss)]))*10000+MINUTE(SELECTEDVALUE('Report'[Time Spent (hh:mm:ss)]))*100+SECOND(SELECTEDVALUE('Report'[Time Spent (hh:mm:ss)]))