Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
Rinkin_Vaghani
Frequent Visitor

Data Not Showing properly in desktop app

Even after date filtering, date is not showing properly. See screenshot.

I have filtered date till 1 feb 2020, but chart is still showing date upto Dec 2021.

Any date filter is not working. I dont know what to do.

Your help would be appreciated.

 

Rinkin_Vaghani_1-1628082072252.png

4 REPLIES 4
Ashish_Mathur
Super User
Super User

Hi,

The fields that you drag to the X axis of the chart and the slicer should both be from the Calendar Table.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

It is same and varified again. It seems problem is with measure. any way to ignore if specific value?

 

 

Hi,

Share the link from where i can download your PBI file.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
lbendlin
Super User
Super User

Change your measure to return BLANK() after the last date you have data for.

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors