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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.

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