Hi guys,
I have a issue with filter of a report, the report filter 10 last years in a measeure calculeted but the user final want see of the selection years those have not amount, for example years 2018 and 2016 (check image) the request user final show report years load with value 0. I dont know what to do for solved issue. help me please.... Regards
Hi JohnR1,
I have reproduced your issue. In table DETALLE_CASOS, there's NULL value, right? I have made three sample tables(DETALLE_CASOS, HISTORICO, TIEMPO) like below based on your description:
I then create a measure using your DAX formula and use the measure to create a line chart, I reproduced your issue like below.
To solve this issue, you should replace NULL with 0, click Query Editor->Replace Values.
After applied&close, you can see value 0 in the line chart.
PBIX for your reference: https://www.dropbox.com/s/0dscajn1m1rwzkt/filter%20dax.pbix?dl=0
Regards,
Jimmy Tao
Hi JohnR1,
I have reproduced your issue. In table DETALLE_CASOS, there's NULL value, right? I have made three sample tables(DETALLE_CASOS, HISTORICO, TIEMPO) like below based on your description:
I then create a measure using your DAX formula and use the measure to create a line chart, I reproduced your issue like below.
To solve this issue, you should replace NULL with 0, click Query Editor->Replace Values.
After applied&close, you can see value 0 in the line chart.
PBIX for your reference: https://www.dropbox.com/s/0dscajn1m1rwzkt/filter%20dax.pbix?dl=0
Regards,
Jimmy Tao
Helpful resources
Fabric Data Days
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Power BI Monthly Update - October 2025
Check out the October 2025 Power BI update to learn about new features.
FabCon Atlanta 2026
Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
