Forum Discussion
Hide a Column in a Table Visual - BI Service Report
- 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 createdNow 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.
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.