Can you use a value of the data type time for a stacked bar diagram?

[jwmvanderwilk]

Can you use a  value of the data type time for  a stacked bar diagram?

In Power BI Desktop the only value is (distinct) count, but I want a SUM. I've created a measure, but same result.

I use the same query for a paginated SSRS report with no problems. 

Now I want to rebuild the report to Power BI Desktop report.

Thanks in advance,

Johan van der Wilk

[v-xjiin-msft · Accepted solution]

Hi @jwmvanderwilk

As I know, currently it is not supported to sum time in chart.

And here's a workaround you can refer:

Since you have already created a measure to sum time. You can put this measure in Tooltips. Then when you move your mouse on bar, it will show the total time. Like:

 

Thanks,
Xi Jin.

[jwmvanderwilk]

Thanks Xi for your reply,

I hoped that I did something wrong, but it's apparantly not possible.

Tooltip is an option, but I think I will change the datatype from Time to Integer and interperter the values as milliseconds.

Probably I will combine both: Sum the miliseconds and use the measure as a tooltip for readibility.