Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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
User | Count |
---|---|
86 | |
82 | |
68 | |
64 | |
55 |
User | Count |
---|---|
120 | |
99 | |
91 | |
83 | |
65 |