Bar Chart by Day for a Call Logging Database

[Dean-Spooner]

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. 

[sanjeev803]

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]

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]

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]

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

[sanjeev803 · Accepted solution]

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]

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? 

[Dean-Spooner]

Hi,

Can anyone offer any assistance on this please?