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 th...
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
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

    • sanjeev803's avatar
      sanjeev803
      Helper I
      6 years ago

      Please share sample data so that I can copy and create the visual.

      • sanjeev803's avatar
        sanjeev803
        Helper I
        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