Forum Discussion

Dean-Spooner's avatar
Dean-Spooner
Frequent Visitor
6 years ago
Solved

Bar Chart by Day for a Call Logging Database

Hi All,

 

I am new to the power BI community and this is my first post. I have a call logging system that has a database and the columns I currenty have selected are the call referece number and the date the case was created. I have filtered on the created date to show the current month. 

 

What I am looking to do is create a bar chart that lists the number of calls logged each day for the current month.

 

If you require any other information then please let me know. 

 

 

 

Need Help
  • sanjeev803's avatar
    sanjeev803
    6 years ago

    Create a simple measure,

    Count = COUNT(Sheet1[Created on])
    Drag created date to axis and remove everything else from data heirarchy except day.

    Apply visual level filter as shown below.

     
    and you will get below visual.
     
     
    I Hope this will help.
     
    Cheers!
    Sanj

7 Replies

  • sanjeev803's avatar
    sanjeev803
    Helper I
    6 years ago

    Hi -  Select the Bar chart > Drag created on field to Axis > Drag Id to Value field  > Click on ID in field section and select count.

    this will display only count by date. To keep it to current month only you can apply filter from filter pane for TOP N using date/month column.

    Please reply in case you need further help.

     

    Cheers!

    Sanj

    • Dean-Spooner's avatar
      Dean-Spooner
      Frequent Visitor
      6 years ago

      Thank you for the reply Sanj, 

       

      There doesnt seem to be an option for a standard bar chart, 

       

      I have tried your advice above on stocked column chart and clustered column chart and get the results below which just seems to show whether a call was logged on a day or not and not the amount per day.  I applied a relative date filter to the created date to only display results for this month. 

       

      Do you have any further advice? 

       

       

       

      • Dean-Spooner's avatar
        Dean-Spooner
        Frequent Visitor
        6 years ago

        Hi,

         

        Just as one more thing I have made sure the format is set to a date for the created on column. It doesnt have a calendar icon next to it though so is there some sort of conversion of this column i need to do to be able to group the dates together? 

         

        Thanks in advance 

         

        Dean