Unable to get the count in the bar graph?

[Anonymous]

Hi 

I am having an order table that has the date and order number. I would like to see how many orders we got per day through the bar graph. I have the date on the x-axis and the order number on the y-axis.  I changed the order number into count however it's not coming. 

My order and date columns as below 

I want to calculate, for example, in 24/09, there will be two orders. So I want to visualize each day with total number of orders. My order number column in text format and date in date format. I am getting below graph

It's making count, I need to sum it

Please advise

[Ashish_Mathur · Accepted solution]

Hi,

In the Query Editor, split the Request date field into Date and Time.  Create a Calendar Table and build a relationship from the Date column of your Table to the Date column of your Calendar Table.  To your visual, drag the Date column from the Calendar Table.  Write this measure

Measure1 = countrows(Data)

Hope this helps. 

[amitchandak]

@Anonymous , Create a date column like this

Date = [torderrequesteddate].date
or
Date = date(year([torderrequesteddate]),month([torderrequesteddate]),day([torderrequesteddate]))

and use that

better join it with date tbale and use date from there

To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :radacad sqlbi My Video Series Appreciate your Kudos.