Forum Discussion

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

Anonymous

Not applicable

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.