Date Slicer Does not Update Date Axis (Due to SMA Measure)

[swami84]

Hi,

     I am rather new to Power BI. I created a line plot and added Simple Moving Average (SMA) measure as follows

SMA (31 day) = AVERAGEX(DATESBETWEEN(aycb_auth_rate[customer_created_date].[Date], MAX(aycb_auth_rate[customer_created_date]) - 30, MAX(aycb_auth_rate[customer_created_date])), CALCULATE(SUM(aycb_auth_rate[approved])/COUNT(aycb_auth_rate[order_status_formatted])))

I also added a date slicer. When I move the date slicer to specific dates, the X-axis remains the same and does not update. If I remove the SMA measure, it updates just fine. I am not sure how to edit SMA measure to enable axis updates with slicer. Please help!

[v-jianboli-msft · Accepted solution]

Hi @swami84 ,

This problem is caused by the date with the hierarchy, just change it to Date.

Final output:

Best Regards,

Jianbo Li

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

[v-jianboli-msft]

Hi @swami84 ,

Which table data is used in the fields of your slicer, the fact table or the date table?

Which field is used in the x-axis of your line chart?

Please try to create a slicer using the date in the date table as the field for the X-axis and use that field.

If that does not work, please provide me with more details about your table and your problem or share me with your pbix file after removing sensitive data.

Refer to:

How to provide sample data in the Power BI Forum

How to Get Your Question Answered Quickly

Best Regards,

Jianbo Li

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

[swami84]

I believe I am using the fact table field in slicer

I am using the same field (customer created date) for both X-axis and slicer

The pbix file can be found here
https://drive.google.com/file/d/1F1xqe31MNVkNjqyqFvdlBhdGft2wrlF1/view?usp=share_link

Thanks again for your help

Thanks