cancel
Showing results for
Did you mean:
Highlighted
Regular Visitor

## Series graph with date

Hello,
I have one column with the date and other with the value for this date (it corresponds to different measurements). I want to do a graph that shows each point and in the x axis the correspondent day. But when I put the day in the axis appears the cumulative value per day....

Index     Date_my   Value

 0 01-01-2016 1 1 01-01-2016 2 2 01-01-2016 1 3 02-01-2016 3 4 02-01-2016 1 5 02-01-2016 3 6 03-01-2016 5 7 03-01-2016 1 8 03-01-2016 2

There is any way to display the information that appear in the first graph but in the axis appear the day?

3 REPLIES 3
Established Member

## Re: Series graph with date

Hi @Sea_and_Anne, I do not understand what you want the result to look like. Please could you describe it much more exactly?

Regards.

Pavel

Regular Visitor

## Re: Series graph with date

Sure!
Sorry , i will try to be more clear.

So, my table have plenty register per day, that correspond to different measures during the day.
I want a graph that shows the diferent points during the day, as the follow picture:

but in the X axis, i want to show the correspondent day of the measure...

In excel if i select the data and insert a area graph i can select the Date as the data of the horizonatal axis label ....and works well..

but i don't know how do this on power bi ...

Community Support Team

## Re: Series graph with date

In your scenario, if you want to display each data point in one day and set the date column as X-axis, it cannot be achieved in a area chart. To work around this, I would suggest you select clustered column chart.

Add a calculated column to table:

`Column 2 = COUNTROWS(FILTER(Graph,EARLIER(Graph[Index])<=Graph[Index]&&EARLIER(Graph[Date])=Graph[Date]))`

Create column chart as below:

Best regards,
Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.