How to Show/Hide fields dynamically in Power BI

source:

Did you know that you can allow users to dynamically choose the fields they want to see in a Power BI visual? This can be done using the Field Parameters feature in Power BI in less than 10 minutes.

I have used the same financial dataset used in the How to create a Power BI report in 15 mins : For absolute beginners article in this as well.

Let’s get right to it, shall we?

1. Select “Fields” from “New Parameter” option in the Modeling tab

2. Specify a name to the list of fields under “Name”, select the fields required and click create. Make sure the Add slicer to this page option is enabled.

Now you will see a slicer with all the fields you selected on the Power BI canvas. In addition, in the Fields panel you will again see the selection list we created.