cancel
Showing results 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

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

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!

1 ACCEPTED SOLUTION
Anonymous
Not applicable

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

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

6 REPLIES 6
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.

Community Champion

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)``````

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

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

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

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

hours =[Minute]/60

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - August 2024

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

#### Fabric Community Update - August 2024

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

Top Solution Authors
Top Kudoed Authors