Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
05-21-2022 09:37 AM - last edited 05-21-2022 10:25 AM
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
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?