Time in Pie Chart Graph

Anonymous

---

I´m trying to show a measure of acumulative time in a Pie Chart.

But there is some problem and I can't.

---

So what is the problem? Could you be more precisely with it? Is that the Pie Chart doesn't show any data in report like below?

If that is the case, I would suggest you to change the measure "Total Navigation Time" to calculate the accumulative time in seconds, or in minutes/hours with a numeric type instead of time type(HH: MM: SS). Because the Values of Pie Chart doesn't support time type data, so it won't display anything. See my sample below.

To make it simple, I just assume you have a table called MyTestTable like below.

Use formula below to create the measure "Total Navigation Time" to calculate the accumulative time in seconds.

Total Navigation Time in second =
HOUR ( MyTestTable[Time Total] ) * 3600
    + MINUTE ( MyTestTable[Time Total] ) * 60
    + SECOND ( MyTestTable[Time Total] )

Then show the measure in a Pie Chart in report.

Regards