Forum Discussion
Graphing after a group by command
Hi there, I'm new to power BI and I am building a dashboard for my company's IT department. I am trying to graph the number of tickets received on the y-axis, and associated application on the x-axis. To accomplish this, I did the same thing as I've done in the past. I first duplicated the base table with all of the data, and then I did a group by command and grouped by associated application. This gives me the exact table I need, with the associated app in the first column, and the count of all tickets for those apps in the second. The problem is that when I go to make a bar graph with this data, the y-axis displays the COUNT OF COUNT, meaning that it's simply a static 17 (the number of total apps) across all x-values. I need to be able to see the individual count of each app on the y-axis. Any help would be much appreciated.
If that was too easy for you, I would also appreciate some guidance on how to eventually add a date slicer for this graph. The date for each ticket is already in the base table that I mentioned before.
Thanks!
Pierre
First, you probably don't need to duplicate the table. If you have a table that has the application and something like a ticket number, you can plot the application in the x-axis and count (or distinctcount) the ticket number in the y-axis.
If you still for whatever reason wanted to keep your grouped by table, I believe you could just change your count to a sum which should show you what you're expecting.To add a date slicer, click the highlighted button in this screenshot and add your date as the field.
1 Reply
First, you probably don't need to duplicate the table. If you have a table that has the application and something like a ticket number, you can plot the application in the x-axis and count (or distinctcount) the ticket number in the y-axis.
If you still for whatever reason wanted to keep your grouped by table, I believe you could just change your count to a sum which should show you what you're expecting.To add a date slicer, click the highlighted button in this screenshot and add your date as the field.