Forum Discussion

ozman750's avatar
ozman750
Regular Visitor
4 years ago
Solved

Line chart for dates - count error

Hi guys, 

 

I am new to BI so your help will be appreciated.

 

I am trying to create a line/ or scatter chart to show, the finish date of a task against a program revision (Tap R). But every time I try, BI counts the date values.

 

I created it in excel as shown in the pic. I also added a data screenshot. 

 

Please note: Tap R values are repeating - the idea behind is, to filter for each task. Like I have filtered for one of the Tasks i.e. MTE

I have already created this via downloading additional visuals as you can see on BI screen shot - Finish date vs Tap. Problem with this visual is, its restricts formating...

 

  • Hi, ozman750 

    Do you mean that you want to present the dates (finish date) on the Y axis?

    It's hard to do with Power BI native visual. You can refer to this thread to create a R visual.

    dates on Y axis 

    Best Regards,
    Community Support Team _ Eason

3 Replies

  • v-easonf-msft's avatar
    v-easonf-msft
    Community Support

    Hi, ozman750 

    Do you mean that you want to present the dates (finish date) on the Y axis?

    It's hard to do with Power BI native visual. You can refer to this thread to create a R visual.

    dates on Y axis 

    Best Regards,
    Community Support Team _ Eason