Forum Discussion

RachnaV's avatar
RachnaV
Icon for Helper I rankHelper I
4 years ago

How to conditionally hide report pages

I have a board report that has around 50 pages, first three pages display summary of various Board Balanced Score Card KPIs under various sections like Main KPIs,Finance KPIs, Employee related KPIs a...
Need Help
Tips and Tricks
v-cazheng-msft's avatar
v-cazheng-msft
Icon for Community Support rankCommunity Support
4 years ago

Hi RachnaV,

 

You may consider combining Bookmark navigator/Page navigator with hide pages, bookmarks, buttons features.

The steps are as follows.

1 Add buttons on each report page to back to the overview page

2 Create Bookmarks to record the hide and show status of each report page

3 Insert Bookmark navigator or Page navigator on the overview page so users can switch between these report page

 

Also, here is an sample pbix file you could refer to. You may publish to your workspace and test on it to see whether it fulfills your needs.

 

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please let me know. Thanks a lot!

 

Best Regards,    

Community Support Team _ Caiyun

RachnaV's avatar
RachnaV
Icon for Helper I rankHelper I
4 years ago

Hi Caiyun,

 

Thanks for the revert but this does not achieve the functionality that I am looking for. Actually the flag IsAnExceptionKPI would have different values for different months so a KPI may be an exception KPI for a particular month say June'22 but might not be an exception KPI in July'22. So when a user selects month as June'22 (there is a filter on the top of the page to select FiscalYearMonth combo) the detailed page for the exception KPI should become visible but for July'22 it should be hidden. How can we achieve this functionality?