In a PBI Embedded scenario (app as a service), users want the ability to show/hide a column in a table.
We need to show count of text fields in the total bar, which again is not supported in Power BI. But somehow managed to create a measure that will show texts in the table and aggregation (count of rows in our case) in the total bar. But this has a limitation that it requires the original column to be in the table visualization, so it is required that we are able to hide it.
We are exploring ways to alter a single table field output to display from cumulative sum to % values basing on text selection.
And, the show and hide column feature is very useful. This feature is available in other tools like SAP WebI.
I needed to sort a table by calculated column but did not want to show the column because it took up space
I think the ability to hide a column in a visual is basic functionality, especially if you want to create dynamic measures to use the hidden column for filtering rows!
We could do this with some conditional creativity in SSRS.
Building a drop down to give the user the ability to "show" the columns they want would be huge!
Needed: hide and show table columns managed by the end user.
* A multinational company with a business unit in each country.
* Every country does maintain the item numbers themselves.
* A worldwide item number format is mapped to the local ones
* Depending on the role the users needs Item and Description:
-> Worldwide only
-> Local only
Without this feature we
* either give to much information for some users
* or we have to use bookmarks with a couple of duplicated visuals (Difficult to maintain)
* or we have to create a separated report for every user type (Ugly to maintain)
I totaly agree with Jhinge Pranav. A customer with the requirements above is currently using 200 Qlik licenses and asked us to showcase Power BI. Low brainers like this feature can be a game changer...
The work around of making the font and the background white really doesn't work for a wide column. I have values with the same title, but different ids. I need to show multiple rows of titles where the ids are different and I need the measures to apply the current id, but the ids are ugly and no one wants to see them. Having this feature would be perfect. I hid columns all the time with SSRS. It is even better if you can change the visibility of a column using an expression.
This feature is most needed
This would eliminate the need to create duplicate tables based on whether you need a field to be visible or not.