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

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
ribs
New Contributor III

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
Esteemed Contributor III

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

Helpful resources

Announcements
Top Solution Authors
Users online (10,586)