How to Hide Columns with No Data in Power BI

Power BI is a powerful data visualization tool that can help businesses make better decisions by presenting data in a user-friendly format. However, it’s important to only show relevant data to avoid cluttering the visualizations. In this tutorial, we’ll go over how to hide columns with no data in Power BI.

Steps To Hide Column with No Data in Power BI

The following steps will guide you to successfully hide columns with no data in Power BI

Step 1: Open Power BI and select the report you want to work on.

Step 2: Click on the “View” tab in the ribbon and select “Data” from the “Visualizations” section.

Step 3: Locate the column you want to hide in the “Fields” pane on the right-hand side of the screen.

Step 4: Right-click on the column and select “Hide” from the drop-down menu.

Step 5: Repeat this process for any other columns you want to hide.

Step 6: To show a hidden column, simply right-click on it and select “Unhide.”

READ ALSO:

Step 7: If you want to hide columns with no data automatically, you can use a measure to check if the column has any data. Here’s how:

Click on the “New Measure” button in the “Fields” pane.
Enter a name for the measure and the following formula:

lessCopy codeColumnHasData = IF(COUNTROWS('Table') > 0, 1, 0)

Replace ‘Table’ with the name of your table.
Click on “OK” to create the measure.

Step 8: Now, right-click on the column you want to hide and select “Conditional Formatting” from the drop-down menu.

Step 9: In the “Value” section, select “Field Value” and choose the measure you just created from the drop-down list.

Step 10: In the “Format” section, select “Background Color” and choose the same color as your report background.

Step 11: Click on “OK” to apply the conditional formatting.

Step 12: The column will now be hidden if there is no data in it.

Conclusion

In this tutorial, we’ve shown you how to hide columns with no data in Power BI. By doing so, you can keep your reports clean and clutter-free, making it easier for users to focus on the data that matters. If you have any questions or comments, please feel free to leave them below.

See the video below for more explanation