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 Datediff in order to calculate the Selling Time. Now I want to visualize this Selling time across multiple categories. However, when I am trying to visualize it by using a bar graph, for example, I could see the sum total of Selling Time (Duration in days) for each category. Example: Home 120 days, Furniture 100 days etc.. which is actually not representing a better view.

What could be the best approach to Visualize Selling Time ?

Thank You.

Here is the sample snapshot of the scenario:

Example of the scenario

Need Help

3 Replies

  • 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.