Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
ABill234
Helper I
Helper I

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

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

 

Screenshot 2020-08-19 at 9.12.32 AM.png

 

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!

1 ACCEPTED SOLUTION
Anonymous
Not applicable

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).
Karlos_0-1597825786502.png

View solution in original post

6 REPLIES 6
v-xicai
Community Support
Community Support

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.

pranit828
Community Champion
Community Champion

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)




PBI_SuperUser_Rank@1x.png


Hope it resolves your issue? 
Did I answer your question? Mark my post as a solution!

Appreciate your Kudos, Press the thumbs up button!!
Linkedin Profile
harshnathani
Community Champion
Community Champion

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
Not applicable

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).
Karlos_0-1597825786502.png

Thank you all so much for your quick responses!
amitchandak
Super User
Super User

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

 

hours =[Minute]/60

 

 

Helpful resources

Announcements
Sept PBI Carousel

Power BI Monthly Update - September 2024

Check out the September 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Sept NL Carousel

Fabric Community Update - September 2024

Find out what's new and trending in the Fabric Community.