Forum Discussion
Displaying column based on slicer selection
Hello,
I have a requirement whereby I need to display additional column based on slicer selection.
In the example below, I have a table showing continent country and debt. As you can see below, USA is duplicated showing DEBT as YES and NO which makes no sense to the user.
What I would like is to display Continent and Country initially while debt is Hidden. Debt column should only be displayed when I make a selection of country.
how do I achieve this requirement?
2 Replies
Hello Wafarian ,
This this could be acheived using field parameters.
check this link for instructions https://learn.microsoft.com/en-us/power-bi/create-reports/power-bi-field-parameters
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Hi,
thanks for the link. It does't specifically meet my requirement as users needed choose the column they want to hide and display.
This can be achieve in SAP analytics cloud by having 2 tables and using scripting to set visibility of the tables to true or false.
