Forum Discussion

peid's avatar
peid
Regular Visitor
3 years ago
Solved

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...
Need Help
  • Syk's avatar
    Syk
    3 years ago

    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. 

     

Syk's avatar
Syk
Resident Rockstar
3 years ago

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.