Power BI Field Parameters — A Quick way for Dynamic Visuals
The field parameter feature is released in the May 2022 update of power bi as a preview feature. It allows users to dynamically change the dimensions or measures in a visual. This feature allows developers to create a dynamic report where end-user can change Axis/Row/Column or Measure/values in a visual/page.
For dimension/Axis slicer, it can completely replace the need for bookmarks and unpivot table columns to have a dynamic axis. This is one of the most awaited features.
For the measure slicer, it replaces the old technique of creating an independent table and then writing down a measure, where one can change the measure in the visual based on slicer selection from the newly created table. In the old technique, there was always an issue when the new measure is having measures with different formats like percent vs number.
There is one more alternative for the measure slicer, which is the calculation group. And this will still hold strong as it allows one to convert measure to dimension, which is not possible in the case of field parameter. Calculation groups still hold relevance for scenarios where one needs the measure on the top of the dimensions in the matrix column and when one needs a measure in small multiples.
Enable the Feature
To enable this feature in Power BI Desktop. Go to File → Options and Settings → Options → Preview Features and enable Field parameters
Check the attached file for details.
A detailed blog on Field Parameter Power BI -https://amitchandak.medium.com/power-bi-field-parameters-a-quick-way-for-dynamic-visuals-fc4095ae9af...
And the video for how we can use that
Click Here to access all my blogs and videos in a jiffy via an exclusive visual glossary using Power BI.
Please like, share, and comment on these. Your suggestions on improvement, challenges, and new topics will help me explore more.
You Can watch my Power BI Tutorial Series on My Channel, Subscribe, Like, and share
Thankyou for sharing this Amit!!
I have a doubt on this, here I am referring 'field parameters test.pbix' file shared by you.
In Axis Slicer FP Tab, I am on State and I have clicked on 'California' bar as shared in below screenshot-
Now, Going to 'Brand', here no brand is showing as filtered to California state and bars are greyed out as showing in below screenshot-
I have further analyzed the data and can see that we have many brands available in California state.
Could you please let me know why this is happening?
