Power BI表格视图调整：隐藏无效子小计百分比列

Hey there! Let's get that table sorted out for you. Hiding those unwanted subtotal percentage columns (filled with -100% or infinite values) while keeping your calculated 2017-2018 Percentage column is straightforward. Here are a few reliable methods:

Method 1: Quick Hide via Visualization Fields Panel #

• Select your table visual in the Power BI report view.
• In the Fields pane on the right, locate the two subtotal percentage columns you want to hide.
• Click the eye icon next to each column name, or right-click the column name and choose Hide.
• Instantly, those columns will disappear from your table, leaving only the final Percentage column visible.

Method 2: Hide via Column Properties (Data View) #

• Switch to the Data view (using the bottom navigation bar).
• Find the table containing your columns, then right-click each unwanted subtotal column.
• Select Column properties from the menu.
• In the properties panel that pops up, check the Hide box and apply the change.
• Return to the report view—your table will no longer display these hidden columns.

Bonus: Remove Calculated Measures (If Applicable) #

If those unwanted columns are DAX measures instead of table columns:

• In the Fields pane, right-click the measure name.
• Choose Remove from report—this will take it out of your table visual entirely.

Note: Hiding/removing columns only affects their visibility in visuals; the underlying data remains intact. You can always restore them later by re-enabling the eye icon in the Fields pane.

内容的提问来源于stack exchange，提问作者rick van der horst