I have a report/dashboard with three pages. There are various tables and matrices on all pages. All data for visualizations are brought in via DirectQuery. This report is published to our workspace.
On Page 1, there is one filter, Company Selection, that selects the target company for the report. This filter syncs to all the pages. The Company Selection acts as the dynamic M query parameter used to query data for all the visualizations.
On Page 2, there are two matrix visualizations. Let's call them Matrix 1 and Matrix 2. Sometimes, there is no data available for Matrix 2, so the table returned is empty. (Matrix 1 should also theoretically be empty, or is simply meaningless in this case.)
Essentially, users/viewers can select a target company to view the report, then export the results (usually to PPT). We don't want Page 2 shown if Matrix 2 is empty. We also don't want an empty/useless Page 2 to be exported to PPT. For these reasons, is there a way to hide Page 2 whenever Matrix 2 is empty?
