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

Score big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount

Reply
ribs
Helper I
Helper I

Disconnected table shows all the values in columns of matrix even though there are no values.

I have Fiscal week values in columns that comes from a disconnected table because I need a sparkline at the end of all the Fiscal weeks(SVG used to recreate the volumes and sparklines). In the rows are the customer  names. This records sales volumes per fiscal week.
Now Fiscal weeks in the column matrix shows all the future weeks with blank data. Is there a way to not to show these weeks?

ribs_0-1748417114412.png

 

1 REPLY 1
lbendlin
Super User
Super User

To suppress the output from being rendered your measure needs to return BLANK() in those scenarios.

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