How can I display the duration in mm:ss in the combined line-column chart on the y-line?

[julckr]

Hi everyone, I would like to display the total distance (kilometers) as a column (y-axis), the date (day) on the y-axis and the duration per kilometer in mm:ss as a y-line in a combined line and column chart. Distance and date work great, but PowerBI does not recognize the duration format from the imported xls. Table is not recognized. Only the number of durations is available for selection.

How can I display the minutes per kilometer in mm:ss format on the y-line in this chart? Invested already 2 hours without finding the solution via try & error.

Many many thanks in advance & BR

Julian

[amitchandak]

@julckr , I doubt you can display mm:ss on the axis.

Even dynamic Format Strings do not show it on Axis -

Dynamic Format Strings