Forum Discussion

OhLookAnError's avatar
OhLookAnError
Helper I
3 years ago
Solved

Visual returning the same data for every date when using CALENDARAUTO()

I am counting rows from "tblA" under two different conditions using these measures:    Cnt of A = COUNTROWS(Filter(tblA, tblA[Column Name] = "A"))   Cnt of B  = COUNTROWS(Filter(tblA, tblA[Column...
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi OhLookAnError ,

     

    As far as I know, trendline should work in cluster column which contains continuous date.

    Below is my sample table which doesn't have continuous date like 'tblA'.

    According to your statement, I think you may use date hierarchy in your visual. Then trendline will not work in analysis pane. Here I suggest you to add [Date] column whether from "Calendar" or "tblA" into X axis field and select X axis type as Continuous.

    For reference: Use the Analytics pane in Power BI Desktop

     

    Best Regards,
    Rico Zhou

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

OhLookAnError's avatar
OhLookAnError
Helper I
3 years ago

FreemanZ I Have a continuous calendar table and I have a calendar generated by the random dates of "tblA". When I use the dates out of tblA I get the correct data in each month but when I use the calendar table I get what might be a sum of all the data in each month. normally I wouldnt care and would just use the calendar out of tblA but I need a trendline and my understanding is that since that is not a continuous calendar, it won't give me the option for a trendline.