Time in Pie Chart Graph

[Anonymous]

Hi Everyone!

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

But there is some problem and I can't.

I have the measure "#Tiempo Total de Navegación (HH:mm:ss)" like this:

Some clue?

[v-ljerr-msft]

@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

[Anonymous]

Hi @v-ljerr-msft !

Thanks for the answer.

That is my problem and that is the solution that I used.

But I would like to know if It was possible to put the datas in the pie chart as date/time like hh:mm:ss.

[v-ljerr-msft · Accepted solution]

@Anonymous

It is not possible to do it currently. You can submit your requirement on Power BI Ideas.

Regards

[Anonymous]

OK, Thanks for your time @v-ljerr-msft.