Skip to main content
Microsoft Idea

Power BI

New

Dynamic Show / Hide Sheets, Visual Objects, Dimensions and Measures in Power BI

Vote (3) Share
Steven Peng's profile image

Steven Peng on 06 Aug 2023 07:16:55

I have been using QlikView since 2014. I am a top QV report developer. Among the top5 QV reports companywide, three are created by me.


The dynamic Show / Hide of QlikView is way better than that of Power BI. It makes it is very easy for developers to create interactive user interfaces.


The Bookmarks approach in Power BI is way clumsy!


We need to use Conditional Enabling by utilizing the Field Parameter to allow users to Show / Hide Sheets (Tabs), Objects (tables, charts, text boxes, etc.), Dimensions and Measures (Expressions). We need to add an attribute in Sheet, Object, Dimension and Measure respectively to accept Field Parameter expressions to determine to Show or Hide. This way is very elegant and flexible.


Once you enable this functionality in Power BI, it will make Power BI report end-user UI design really dynamic!


Thanks.


Steven P