How to Show/Hide fields dynamically in Power BI

Summary

The web content provides a tutorial on how to dynamically show or hide fields in Power BI reports using the Field Parameters feature.

Abstract

The article titled "How to Show/Hide fields dynamically in Power BI" explains a method for users to interactively select which fields to display in their Power BI visualizations. This feature is enabled through the use of Field Parameters, which can be set up in under 10 minutes. The tutorial uses a financial dataset, the same one from a previous article on creating Power BI reports for beginners. It outlines a three-step process: selecting "Fields" from the "New Parameter" option in the Modeling tab, naming and selecting the desired fields, and finally, adding a visual to the canvas and using the created selection list to dynamically update the table based on user choices. The author encourages readers to leave feedback if they find the guide useful and provides links to additional Power BI resources and articles on Medium.

Opinions

The author believes that the Field Parameters feature is a valuable tool for customizing Power BI visualizations.
They suggest that the process of setting up Field Parameters is straightforward and quick.
The article implies that interactive and dynamic reports are beneficial to users, enhancing their experience with Power BI.
By providing a step-by-step guide, the author conveys that even beginners can effectively use advanced features in Power BI.
The inclusion of a financial dataset as an example indicates the author's view that the tutorial is applicable to real-world scenarios.
The encouragement for reader feedback and the sharing of additional resources reflect the author's commitment to community engagement and continuous learning within the Power BI community.

How to Show/Hide fields dynamically in Power BI

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.

Let’s get right to it, shall we?

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.

3. Now add the required visual onto the canvas and select the Selection List

THATS IT! Now, if you select field names from the selection list slicer, you will see the table getting dynamically updated according to the selection made.

Thanks for reading and do leave a clap if you found this useful!

More articles on Power BI (full list here),

If you are interested in Machine Learning, check out this list.

How to Show/Hide fields dynamically in Power BI

I earned $7.67 in 3 Weeks — Medium

I was accepted to the Medium Partner Program exactly 3 weeks back. During these 3 weeks I earned $…