How to get the card visulisation to divide by 60 every time it shows a number

[ABill234]

Hi all! Im really new to power bi and was wondering if anyone can help me out! I basically have a card visualisation which displays a number of minutes

I want this number to display in hours! its only a single line of text on the sharepoint list. 

I was thinking either is it possible to divide this number by 60 every time it shows up a value or some how format it so it displays the amount of hours. I dont want to change it from single line of text on the sharpeoint list as the list is also part of a flow that I have running which will mess things up!

Please help! and thanks in advance!

[v-xicai]

Hi @ABill234 ,

You may create measure like DAX below .

Hour =
IF (
    ISNUMBER ( [Time] ),
    DIVIDE ( [Time], 60 ),
    DIVIDE ( VALUE ( [Time] ), 60 )
)

Best Regards,

Amy 

Community Support Team _ Amy

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

[Anonymous]

HI @ABill234 

First, I would check if the data is a number or not, then divide it.

Card_by_60 = 
        IF(ISNUMBER([Data]),DIVIDE([numerator],60,0),0)

[harshnathani]

Hi @ABill234 ,

See if this helps

https://community.powerbi.com/t5/Quick-Measures-Gallery/Chelsie-Eiden-s-Duration/td-p/793639

https://www.powerbitalks.com/2019/12/convert-seconds-to-hhmmss-format.html

Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)

[Anonymous · Accepted solution]

You're going to have to create a measure, it's going to go something like this

No hours : DIVIDE(SUM('YOUR TABLE NAME'[YOUR COLUMN NAME),60)

Replace the table name with the table name and replace the column name with the column name (hour).

[ABill234]

Thank you all so much for your quick responses!

[amitchandak]

@ABill234 , which format is this number is. If it is number, then you have to create a measure

hours =[Minute]/60