Forum Discussion

MikeGanem3's avatar
MikeGanem3
Helper I
1 year ago
Solved

Hide a Column in a Table Visual - BI Service Report

Is there a simple way to Hide a Column in a Table Visual in BI Service Report? If no,t then, how do I make a column in fixed width and not extendable?
  • v-menakakota's avatar
    1 year ago

    Hi MikeGanem3 ,

    Thank you for reaching out to us on the Microsoft Fabric Community Forum.

    To hide the Salary column in a table visual is done by using  Field Parameter in Power BI Desktop, follow these steps:

      • Choose the required columns (including Salary) and add them to the Table Visual.
      • Navigate to Modeling → New Parameter → Fields.
      • Set the Parameter Name as parTableVisual.
      • Select the relevant table and check the columns that were added to the Table Visual.
      • Uncheck the option "Add slicer to this page".
      • Click Create Parameter

     


    Then Parameter is created

     

    Now select the new table visual and select the Parameter now both the Tablevisuals are  Identical. Select the Filter and drag the Parameter to the filter pane select all columns except which you want the users to not to be visible(salary)

    Now remove the first visual in which salary column is present and publish the other.
    If this post was helpful, please give us Kudos and consider marking Accept as solution to assist other members in finding it more easily.
    Regards,
    Menaka.