Forum Discussion

Bebs's avatar
Bebs
Icon for Helper II rankHelper II
3 years ago
Solved

Hide some columns in matrix

Hello :), I'm displaying a p&l table in Power BI,columns are like : Year 2022 Quarter 1 2 3 4 For each Quarter you have 3 columns Budget, Turnover, Vs. Is it possible to hide some turnover and v...
Need Help
  • v-yadongf-msft's avatar
    v-yadongf-msft
    3 years ago

    Hi Bebs ,

     

    If you want to hide some columns, I suggest you create a table visual instead of a matrix visual, because the table visual can be more convenient to hide the columns.

     

    1.Select "Specific column"

    2.choose the column you want to hide into "Series

    3.open "Apply to header" & "Apply to total " & "Apply to values"

    4.Set "Text color" & "Background color" to white.

    Then the "Value" column will be hiden:

     

    Best regards,

    Yadong Fang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

v-yadongf-msft's avatar
v-yadongf-msft
Icon for Community Support rankCommunity Support
3 years ago

Hi Bebs ,

 

If you want to hide some columns, I suggest you create a table visual instead of a matrix visual, because the table visual can be more convenient to hide the columns.

 

1.Select "Specific column"

2.choose the column you want to hide into "Series

3.open "Apply to header" & "Apply to total " & "Apply to values"

4.Set "Text color" & "Background color" to white.

Then the "Value" column will be hiden:

 

Best regards,

Yadong Fang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.