Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hi All,
Can you please help me how to hide "Column A" in table but that column should be in order.
For example.
Thanks,
Jeyakumar.
Hi @ujeyakum,
On PBI if you rigth click the column name or table you can select the option Hide, this will hide the column from the visualization however you are abble to use it in your measures and calculations and is visible on the tables view in a grey format.
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em Portuguêshow about dynamically by selecting the unwanted columns from a slicer?
Hi @ujeyakum,
You could adjust the column width manually. In your table visualization, hover your mouse over your column heading that you want to "hide" and move it to the right until the mouse cursor changes to a <-||->, then you could adjust the width of this column.
For the better visualization, you 'd better turn off the Word wrap in the format pane. The below should be your expected output.
Hope it can help you!
Best Regards,
Cherry
Hi Cherry,
Thanks for your reply.
I did the same but when you export the report it showing the column. How can i avoid that also.
Can you pls help me on this.
Thanks ,
Jeyakumar.
Hi @ujeyakum,
It seems that there is no options for us to achieve it in Power BI currently.
I suggest you could vote the ideas below which has been submitted in Power BI ideas forum and add your comments there to improve Power BI and make this feature coming sooner.
Allow Table and Matrix Data Exports to Match PowerBI Visual
Best Regards,
Cherry
If you right click on column you will get options as screenshot.
select the hide option that particular column will be hide.If you want you can unhide the column
Regards,
Bajee.
Hi Bajee,
Thanks for your reply.
We are able to hide the column in a table, but when we export the data its showing with hidden column as well.
Can you please help me with this.
Hi @ujeyakum,
What you want is to keep the Sr.No. in order?
If this is the point try to do the sort order choosing the column you want to sort the values by default. Not really sure if irt will work with your dataset since there isn't to much information.
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em Português
Yes, When you export the data from visual still we can able to see hided columns.
I don't thing so we can archive this.
Regards,
Bajee.
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
113 | |
109 | |
107 | |
92 | |
67 |
User | Count |
---|---|
161 | |
129 | |
129 | |
92 | |
91 |