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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
cchp07
Frequent Visitor

Don't Show Items With No Data For Date Range

I am wondering if there is a way to NOT show items in a matrix with no data passed a certain date range.

 

If the item has data after the date range then it would show again. 

 

I do know about "Show Items With No Data", but I am looking for something a little different. 

 

Still needs to show Items if they had data yesterday, but if it was totally blank from 14 days back then do not show the item. 

 

Example of the current matrix -->

 

Example.PNG

 

1 ACCEPTED SOLUTION
sp8
Helper II
Helper II

@cchp07 

You can set a filter on the visual.

Create a Calculated Column that has 1 if the data you want is there and 0 if it's not.

Then filter the visual based on that Calculated Column.

 

If you need more details, please share the format of your input table.

View solution in original post

1 REPLY 1
sp8
Helper II
Helper II

@cchp07 

You can set a filter on the visual.

Create a Calculated Column that has 1 if the data you want is there and 0 if it's not.

Then filter the visual based on that Calculated Column.

 

If you need more details, please share the format of your input table.

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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