Forum Discussion
Helper IData category duration not working
That will not work because the bar chart needs a number or a count and you are providing a text value.
The option you have is to do the normal sum and then use the previous measure as a tooltip.
Super User
Helper II'd like to use a bar chart in Power BI to compare average durations of different departments.
- MFelix
That will not work because the bar chart needs a number or a count and you are providing a text value.
The option you have is to do the normal sum and then use the previous measure as a tooltip.
- danielakunz
Okay thank you. Do you think its possible with Power Query?
- MFelix
You can convert the column to a duration column, however when you place that in a chart visualization you will get the values in numbers and not in hours minutes format.
Please ceck the post below with an example of the solution in the query editor.