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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

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

 

 

Join us as experts from around the world come together to shape the future of data and AI!
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview.
️ November 12th-14th, 2024
 Online Event
Register Here

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 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.

October NL Carousel

Fabric Community Update - October 2024

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