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
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
      • Dean-Spooner's avatar
        Dean-Spooner
        Frequent Visitor
        6 years ago

        Hi,

         

        This doesnt seem to like it either :( 

         

        I have created the measure called count and put this as the value and "created on" as the axis. 

         

        The visual comes out like the below. The problem is there is no date hiearchy on my "created on" database column? 

         

        Do I need to create some sort of date hiarchy on the "created on column as it doesnt seem to be interpreting the date correctly?