Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
Hello, would it be possible to display the following line chart with the time in mm:ss instead of seconds? Thank you.
Solved! Go to Solution.
@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
@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
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.