Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hi !
I'm discovering Power BI and can't find a way to translate my excel graph to Power BI. I have a table with this kind of values
Issue Number | Created on | Solved on | Topic |
I240701 | 04/05/2024 12:56:10 | 17/06/2024 10:11:58 | 03H |
This table contains hundreds of lines. I want to have a grouped bar chart, in which I could get the number of issues of a list of certain topic (like 03H and 07B), opened and solved each day. In x axis the dates, on y axis the number of tickets opened and solved, so that on each day I have two bars one for each measure. Plus, I still need to see the days where I have 0 opened and 0 solved.
I tried creating measures and using a DateTable but as I'm new I couldn't find a way to do it.
Would love to hear if somebody could help me !
Thank you in advance !
I just checked and it doesn't work for my requirement. Fields Solved on and Created on are always filled because my extraction comes from all the issues solved. I just have different dates.
Issue Number | Created on | Solved on | Topic |
I240701 | 04/05/2024 12:56:10 | 17/06/2024 10:11:58 | 03H |
I240702 | 10/06/2024 16:24:03 | 17/06/2024 12:11:59 | 07V |
I240702 | 10/06/2024 16:24:04 | 19/06/2024 13:11:55 | 07V |
I240702 | 19/06/2024 15:24:03 | 19/06/2024 15:11:59 | 07V |
For example here I need to have :
Issues created | Issues solved | |
04/05 | 1 | 0 |
05/05... 9/06 (each line for each day) | 0 | 0 |
10/06 | 2 | 0 |
11/06... 16/06 (each line for each day) | 0 | 0 |
17/06 | 0 | 2 |
18/06 | 0 | 0 |
19/06 | 1 | 2 |
Create below measure and check it works for your requirement or not ?
IssuesOpened = COUNTROWS(FILTER('YourTable', NOT(ISBLANK('YourTable'[Created on]))))
IssuesSolved = COUNTROWS(FILTER('YourTable', NOT(ISBLANK('YourTable'[Solved on]))))
Replace with YourTable in above measure.
Check out the September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
104 | |
99 | |
98 | |
41 | |
38 |
User | Count |
---|---|
152 | |
123 | |
80 | |
73 | |
73 |