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
FriedWater
Frequent Visitor

Time on line chart

Hello, would it be possible to display the following line chart with the time in mm:ss instead of seconds? Thank you.

 

FriedWater_0-1650217389062.png

 

1 ACCEPTED SOLUTION
SpartaBI
Community Champion
Community Champion

@FriedWater 
Yes, through conditional format strings in calculations groups.
Create a calculation item with this formula in the format string expression:

"""" & FORMAT(SELECTEDMEASURE()/86400, "nn:ss")

Make sure to only use this item on the measures where you want to use it, wither by putting it in the visual level filter or by adding and if condition to the formula above to work only on the measure you want.

Hope that helps

View solution in original post

1 REPLY 1
SpartaBI
Community Champion
Community Champion

@FriedWater 
Yes, through conditional format strings in calculations groups.
Create a calculation item with this formula in the format string expression:

"""" & FORMAT(SELECTEDMEASURE()/86400, "nn:ss")

Make sure to only use this item on the measures where you want to use it, wither by putting it in the visual level filter or by adding and if condition to the formula above to work only on the measure you want.

Hope that helps

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

July Newsletter

Fabric Community Update - July 2024

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