Display Duration type Columns in Report view and Sort them

[sanjeewauom]

I'm a new user to power bi. I have found out that in the report view when we use a graph and use "show data points as a table" only columns of type text will be displayed. I can display numbers, dates and duration type columns by duplicating and coverting them to type text in power query. But the issue is when I use "show data points as a table" the columns with duration data cannot be sorted in ascending or descending. Kindly help.

Thanks

[amitchandak · Accepted solution]

@sanjeewauom , if data type is time, it will sort. If it duration created as text, then create a sort column and mark that as sort column

You can do this power query for sort column

sort col=  Duration.Days([D1])*1000000 + Duration.Hours([D1])*10000 + Duration.Minutes([D1])*100 + Duration.Second([D1])*100

Else create two column in dax

duration 1 = [d1]

Duration sort =  <Create a logic based on format>

mark Duration sort as sort column for Duration 1 and use that in visual

How to Create Sort Column and Solve Related Errors:
https://www.youtube.com/watch?v=KK1zu4MBb-c

[sanjeewauom]

Many Thanks for your  reply. I will try it out.