Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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:
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
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
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.
I don't see anything wrong. So, what's wrong with @mahoneypat advice and what results do you want?
Janey