Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Vote for your favorite vizzies from the Power BI Dataviz World Championship submissions. Vote now!
TEST =
VAR TotalSeconds =
AVERAGEX(
FILTER(
Table,
Table[Segment] = "1" && Table[Value]="Y"
),
Query1[Seconds]
)
return TotalSeconds<p>The result I got was 438.92 seconds which is correct when I set to my current filters. Is there a way to format this as a "07:19" in my line graph without changing the value to text?
When i clicked Dynamic for Format in Measure Tools I added this format
VAR TotalSeconds =
AVERAGEX(
FILTER(
Query1,
Query1[Segment] = "1" && Query1[value]="Y"
),
Query1[Seconds]
)
VAR Minutes = INT(TotalSeconds / 60)
VAR Seconds = MOD(TotalSeconds, 60) // Round down seconds
RETURN
FORMAT(Minutes, "00") & ":" & FORMAT(Seconds, "00")
When I do this i get a strange value 4397.19
@user35131 I did this once although there was a bug in Desktop that prevented it from working correctly. Maybe they still haven't fixed it? Dates and DateTime in Y - Microsoft Fabric Community
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
Check out the January 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 59 | |
| 59 | |
| 45 | |
| 17 | |
| 17 |
| User | Count |
|---|---|
| 115 | |
| 112 | |
| 38 | |
| 35 | |
| 26 |