Why is my line turning into count instead of values?

[Anonymous]

Hi everyone,

The dates are turning into a straight line. Can anyone help please?

Thanks

[amitchandak]

@Anonymous , On Y-axis you can only have numeric values.

Power bi does not support the date or time there. So it forces an aggregation. You can change that using right on that in visual pane

[Anonymous]

How do I do it sorry?

[v-chenwuz-msft]

Hi @Anonymous ,

This means that the data is the same every year, so the data is not filtered by context.

Please check the relationship between Date until Today table and Today table, whether the cross filter direction is Date until Today to Today table. or the relationship fields are wrong.

Best Regards

Community Support Team _ chenwu zhu

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