Forum Discussion

Sea_and_Anne's avatar
Sea_and_Anne
Helper I
9 years ago

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

001-01-20161
101-01-20162
201-01-20161
302-01-20163
402-01-20161
502-01-20163
603-01-20165
703-01-20161
803-01-20162

 

 

 

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

 

 

Need Help

3 Replies

  • PavelR's avatar
    PavelR
    Solution Specialist
    9 years ago

    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

    • Sea_and_Anne's avatar
      Sea_and_Anne
      Helper I
      9 years ago

      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 ...
      :(

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Microsoft Employee
    9 years ago

    Hi, Sea_and_Anne

     

    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