Forum Discussion
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?
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.
7 Replies
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,
In my table visual, I have 2 columns currently displayed. I want to hide or make invisible the 2nd column and visually display only the 1st column.
In the following visual, I want to make the Salary column invisible to all users.
Employee Salary
JDoe 17000
FLopez 21000
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"
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 ,
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you.Hi MikeGanem3 ,
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you.Hi MikeGanem3 ,
I hope this information is helpful. Please let me know if you have any further questions or if you'd like to discuss this further. If this answers your question, please Accept it as a solution and give it a 'Kudos' so others can find it easily.
Thank you.
