Forum Discussion
How to hide columns in tables dynamically
Hello
I'm using a table to present data for multiple products. However, we have products that do not have text value in specific columns. Therefore, when you choose that product I don't want to show columns that don't have any text. Is there a way to do this in Power BI tables? to hide columns dynamically?
Thank you
Hi , RaffiKouzoudj
If the table you mentioned is an ordinary table visual , I'm afraid it is difficult to achieve the goal you want.
If it is matrix table , please take a try the option of "show items with no data".You can also refer to these related posts for possible workaround .
https://community.powerbi.com/t5/Desktop/How-to-hide-null-columns-in-matrix-table/m-p/561564
https://community.powerbi.com/t5/Power-Query/Hiding-blank-rows-amp-Columns/m-p/1013392
Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
Hi,
This solution works only when have Row, Columns & values sections utilized in Matrix visual.
In my case, i just have only 1 column and 4 measures. I have placed my single column under Rows section and 4 measures under values section. How to hide my measures dynamically in this case including the header labels?
Appreciate any solution that you could offer here.
Hi , RaffiKouzoudj
If the table you mentioned is an ordinary table visual , I'm afraid it is difficult to achieve the goal you want.
If it is matrix table , please take a try the option of "show items with no data".You can also refer to these related posts for possible workaround .
https://community.powerbi.com/t5/Desktop/How-to-hide-null-columns-in-matrix-table/m-p/561564
https://community.powerbi.com/t5/Power-Query/Hiding-blank-rows-amp-Columns/m-p/1013392
Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
