powerbipowerbi-paginated-reports

Is it feasible to hide column in a grid in Power Bi Paginated report


I have found a way to hide a column in the matrix visualisation in Power BI but not in Paginated report, hence question.


Solution

  • In the Design view, you can hide a column by right clicking the column header and selecting Column Visibility...

    Right click header

    then select Show, Hide, or based on an expression

    display options

    To tie showing or hiding the column based on a drop down, create a parameter by right clicking Parameters in the Report Data pane and selecting Add Parameter...

    Add Parameter

    Here are my settings for the parameter:

    Once you have the parameter set, go back into the Column Visibility settings, select based on an expression and click the fx button:

    based on expression

    Then click Parameters and double click your parameter name to add the expression:

    add expression

    When you run the report, you'll see the drop down and the default setting:

    default setting

    You can then change the drop down and click View Report to see the hidden column:

    Show hidden column