Forum Discussion

GuestUser123's avatar
GuestUser123
Regular Visitor
4 years ago

How to Visualize Duration?

Hello Everyone, I am a newbie and I need one help. I have a scenario wherein I have the Start and End Time with me as one of the columns in my dataset. I have calculated the Duration(in days) using ...
Need Help
mahoneypat's avatar
mahoneypat
Microsoft Employee
4 years ago

Please see this article for a good way to calculate and format durations.

Calculate and Format Durations in DAX – Hoosier BI

 

In your case, that might be a measure like this one, and then use the Category column as your legend or axis.

 

Selling Duration = SUMX(Table, INT(Table[End Time] - Table[Start Time])

 

Pat

 

GuestUser123's avatar
GuestUser123
Regular Visitor
4 years ago

Hi mahoneypat Thank you for the response. I created a Selling Time Measure as suggested by you and tried to visualize the same with Category Name in Axis and Selling Time in the Values. However, it still does not represent a great picture. Maybe I am doing something wrong here. Could you please refer to the below snapshot? 

Thank You.

 

  • v-janeyg-msft's avatar
    v-janeyg-msft
    Community Support
    4 years ago

    Hi GuestUser123  

     

    I don't see anything wrong. So, what's wrong with mahoneypat advice and what results do you want?

     

    Janey