override report level filter

[PowerBInewcomer]

Hello Everyone,

I am facing one issue in My line chart which shows Current year, Budget, And PY values I am using report level date filter 

but when I am selecting any date in the report level paramter I am getiing only one values for current and PY year

Ideally i want to show all the values starting from 1st month of the current year  and 1 month of prior year. but my report level date file prevents it.

I have date table conneted to other tables ( one to many) from which i am picking the values.

I want my chart should work on report level date filter.

I tried ALLexcept but still i am not able to get required outpu as it overrides report level filter but it shows only one value for Prior year and current year but i need series from 1 st month of the year and 1st month of prior year.

I need something like below 

but when i select report level filter date i get something like this

I seleted date as 3/31/2024 in above case

Can anyone help here?

Thanks In advance

[Anonymous]

Hi @PowerBInewcomer 

It's hard for me to restore your problem without the source data. If you can't provide the source data because of data security, can you restore your problem by creating a simple sample and provide your sample?

How to provide sample data in the Power BI Forum - Microsoft Fabric Community

Best Regards,
Community Support Team _ Ailsa Tao