Time Period in Metrics Not Reporting on Correct Cycle

[Anonymous]

I have a report that is using a row for each month and a corresponding column for data, I have it set to "No Cycle" on the metrics, but it is reporting at YoY instead of MoM. I have checked that the query in Power Query is listing it as a date and in the table in the Power BI report. There is a join to bring another column in based on the date if that has any significance. 

There are other Metrics in the scorecard that aren't exhibiting this behavior. Any feedback helps. 

Thanks,

Chris 

[v-zhangti · Accepted solution]

Hi, @Anonymous 

It sounds like the issue may be related to the way the metric is defined in the report. When you say that the metric is set to "No Cycle", this means that it should not be reporting on a specific time period, such as month-over-month or year-over-year. However, it sounds like the metric is still reporting on a YoY basis.

One possible solution is to check the definition of the metric and make sure that it is not explicitly set up to report on a YoY basis. You can do this by going to the "Fields" pane in Power BI and selecting the metric in question. Then, check the "Values" section to see if there are any calculations or filters that are causing the metric to report on a YoY basis.

Another possibility is that the join you mentioned may be causing the issue. If the join is not set up correctly, it could be causing the metric to report on a YoY basis instead of a MoM basis. You can try removing the join temporarily to see if this resolves the issue.

Best Regards,

Community Support Team _Charlotte

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