Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
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.
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.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
105 | |
97 | |
75 | |
63 | |
62 |
User | Count |
---|---|
137 | |
105 | |
104 | |
80 | |
63 |