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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel1

Power BI Monthly Update - May 2024

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