Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi, I've searched the forum but I haven't found a solution to this problem.
I have a large database with this structure:
Product | Worker | Date | Duration |
Product 1 | Worker A | 01/01/2021 | 0:17:34 |
Product 5 | Worker A | 01/01/2021 | 1:01:26 |
Product 1 | Worker A | 02/01/2021 | 1:43:13 |
Product 3 | Worker A | 02/01/2021 | 0:34:56 |
Product 1 | Worker B | 01/01/2021 | 0:47:34 |
Product 2 | Worker B | 01/01/2021 | 2:13:08 |
Product 2 | Worker B | 02/01/2021 | 1:03:59 |
Product 3 | Worker B | 02/01/2021 | 0:14:20 |
I want to show it in a dashboard with different graphs, such as a timeline of time invested by product, or a graph bar with total time dedicated to each product with a related filter by worker, etc... The problem is that, in each one of these graphs, on the "duration" axis the time is shown as a decimal number. I've tried the following solutions:
Is there a way to be able to play with this data in the dashboard while showing the data in a normal hh:mm:ss format?
Thanks!
Can you please link to the solutions you have referenced so we know what you've already tried? You could potentially create a measure that returns string and/or removes the second component if I'm understanding your question correctly. What's the wrong result you're currently getting with the two solutions you've tried and what difference would you like? It sounds like you've only tried using columns up to this point? Or have you tried a measure?
Copying DAX from this post? Click here for a hack to quickly replace it with your own table names
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C
I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com
Sure! I've edited the original post, but I've tried both of these solutions:
I've tried using measures, but they don't give me the freedom to play with the data in the dashboard, or I'm using them incorrectly. It would be the perfect solution if I wanted to use cards, but I have three dynamic graphs: one with a timeline with the time inverted by a group of products by day, another where I see the % of time invested in the group of products by total period and a bar graph where I see the total time invested in each product by total period. The last one I use filtering by a worker and by a group of products. Using measures I can't establish this dashboard, as it gives me a pretty rigid result (or that is the only way I know how to use them).
The problems with the other two solutions used are:
I hope I was more clear!
User | Count |
---|---|
141 | |
113 | |
104 | |
78 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |