Is it possible to share a workbook with a few sample rows from each data source so we can see the issue and try to help?
I'm not 100% sure what you are asking for, but it sounds like 2 issues - using filters, and showing empty rows.
A couple of initial thoughts (before you upload a sample workbook as Patrick suggested):
Are the empty rows in the master dataset, or the blend dataset ? Can you change these around and achieve the same visualisation goal ? The logic I'm following with this suggestion is if the empty rows are in the master dataset then the show empty columns/rows menu should work, but if they are in the blend dataset then they might not be coming across.
Further, if you have no pills on the worksheet with the orange indicator, this suggests that no actual blending is occurring. You can put a pill onto a worksheet (use tooltip shelf) without it having an impact on the visualisation, and this might enable showing empty rows/columns.
Note I haven't discussed filters at all. Another way of troubleshooting is to take your filters off, and attempt to show rows/columns, then progressively re-enable the filters to see what was breaking it but I think the first 2 suggestions will be more fruitful in the first instance.
Peter and Patrick,
Thank you both for your responses. I actually forgot I had posted this, but am still struggling through this issue.
I did try removing the two cross data source filters as Peter suggested, and show empty rows did become available. So this does seem like a limitation of the cross data source filter. The challenge is that this set of dashboards has 5 data sources. I have to set the primary data source as the one that has all facility options and not all of our data sources have data for every facility. I'll go back and see if I can change these and what impact that has on the other dashboards that are part of this project.
Patrick, would you be able to add this discovery to the Cross Data Source FAQ document? It looks like even when only using a dimension as a cross data source filter you still encounter some of the limitations of blending. .