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
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!
Solved! Go to Solution.
You're going to have to create a measure, it's going to go something like this
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.
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)
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 |
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)
You're going to have to create a measure, it's going to go something like this
@ABill234 , which format is this number is. If it is number, then you have to create a measure
hours =[Minute]/60
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
117 | |
109 | |
106 | |
92 | |
68 |
User | Count |
---|---|
167 | |
130 | |
129 | |
95 | |
91 |