/
How to reduce clicks to print/view data

How to reduce clicks to print/view data

This page will guide you through the steps to make the matrix more user-friendly and reduce the number of clicks to expand the whole matrix.

Visibility options

  • Here, I have selected the Visibility options according to my requirement.

  • In Hidden, choose one of the following options to set the visibility of this report item the first time you run a report:

    • Select False to display the report item.

    • Select True to hide the report item.

    • Select <Expression> to open the Expression dialog box to create an expression that is evaluated at run time to determine the visibility.

  • InitialToggleState gives you the ability to keep the toggle state on or off when you run the report.

  • In ToggleItem, from the drop-down box, select the name of a text box to which to add the toggle image.

Group Properties

  • In the Row Groups section, select the dropdown of desired column and click Group Properties

 

  • In General group the columns according to requirement

  • Click on Visibility and select Show option for When the report is initially run.

  • Check Display can be toggled by this report item and select the appropriate column and click OK.

  • Click Run and see the results

Related content

Power BI Report Builder Standards
Power BI Report Builder Standards
Read with this
Perform Data Drilling - Data and Analytics
Perform Data Drilling - Data and Analytics
More like this
Export or Save Data - Data and Analytics
Export or Save Data - Data and Analytics
More like this
Data Filters - Data and Analytics
Data Filters - Data and Analytics
More like this
Pre-Defined Reports Overview - Data and Analytics
Pre-Defined Reports Overview - Data and Analytics
More like this