Power Bi filter not working in Online platform

[Anonymous]

Hi,
I am trying to put a relative date filter in my dashboard to show data for 1 month when it loads but also having an option to go back and select the desired date.

It is working completely fine in the desktop version that I am looking at only 1-month data but also having able to select any date to show the desired data but once I publish it online, I am able to see the applied date filter (showing 1-month data) but I am not able to select any other dates on that.

Idk why is this happening? It would be great if anyone can help. Thanks!

[v-henryk-mstf · Accepted solution]

Hi @Anonymous ,

According to your description, there is more flexibility to create MEASURE formulas and combine them with slicers.
Refer to the following.

Amount =
CALCULATE (
    SUM ( FactInternetSales[SalesAmount] ),
    FILTER (
        ALLEXCEPT ( M_DimDate, M_DimDate[Year] ),
        DATEADD ( M_DimDate[Date], -1, MONTH ) && SELECTEDVALUE ( M_DimDate[Year] )
    )
)

If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.

Best Regards,
Henry

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

[amitchandak]

@Anonymous , You have to build your own logic with the selected date and slicer

https://community.powerbi.com/t5/Desktop/Required-custom-date-Slicer-Last-7-days-last-15-days-last-30/m-p/1284966#M561629

Need of an Independent Table in Power BI - Exclude: https://youtu.be/lOEW-YUrAbE