Forum Discussion
Hide a Column in a Table Visual - BI Service Report
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. Can you please give us more details? Do you want to prevent specific users to view a column in a table visual? or do you want to hid it from the whole model for self service?
Usually when you just need to prevent some users to see columns or tables and let others see, you could be talking about Object Level Security (OLS). The feature let you prevent tables or columns for specific users.
I hope that helps,
I want to hide or make invisible a column from all users without removing it from the visual.
If this is not possible then I would like to know if it's possible to display only the last word of the cell value in each row of this column, without using "Add Column -> Extract"