Forum Discussion
Resolver IHide page whenever specific matrix is empty due to missing data queried via DirectQuery
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?
2 Replies
- amitchandak
Super User
user01 , I doubt you can do that.
You can hide page 2 and drill using a measure when there is some data. Using Dynamic page navigation
Very similar to
user01amitchandakThanks for the tip! Unfortunately, I don't believe this will work for our purposes since the hidden pages will not be exported to PPT. Only the "Navigation Page" (the one that is not hidden) will be exported, unless "Excluded hidden report tabs" is unselected, correct?
