For this Power BI video tutorial we will look at all the use cases for field parameters I could think of.
RLS & OLS
- Add field parameters.
- Add field parameter fields to visual.
- Create security roles for row level security.
- Add object level security to the appropriate fields.
Note: When adding OLS, be careful about adding measures related to the field with OLS as it will break visuals for the user. A work around would be to add the measures as field parameters, and then add RLS to the field parameters to hide measures related to fields with OLS.
Conditional Fields
- Create a field with the different formatting if not available.
- Format field.
- Add original field and newly formatted field as field parameters.
- Add fields to visual.
- Add RLS to the fields, creating settings that allow each user role to see the appropriately formatted field.
Note: I used the date field. You can use other fields, translated fields etc.
Bookmarks
- Add filter buttons to page
- 4 Buttons: 2 selected buttons and 2 unselected buttons
- Add field parameter to slicer
- Add new column to field parameter by editing the DAX code as shown in video.
- Create title slicer for the new column field.
- Add title measure to the slicer title.
- Add field parameter filter to filter pane and select a field.
- Go to slicer and select show field values.
- Add field parameter and measures to visual.
- Hide and show objects for the first filter scenario.
- Add bookmark.
- Repeat for the second filter scenario and change filter value in filter pane for the field parameter.
Hierarchy
- Go to field parameter table DAX and add columns as show in the video.
- Create 3 levels: level 1 = field category, level 2 = field title, level 3 = show values for field parameter.
- Add the field parameter table fields in the right order to the slicer and to the visual.
Self-Service
- Create a measure called “none” and make it equal blank.
- Create column field parameters, add none measure to the top of the list.
- Create rows field parameters.
- Create measures parameters.
- Add field parameters to slice and to visual.
Conditional Formatting
- Add field parameter measures to slice and visual.
- In visual formatting click on cell elements.
- Select each measure from the drop down and add conditional formatting.
Credit: PowerÆgg | Nadim Abou-Khalil