Power BI – Field Parameters and Use Cases

[Poweraegg]

For this Power BI video tutorial we will look at all the use cases for field parameters I could think of.

RLS & OLS

1. Add field parameters.
2. Add field parameter fields to visual.
3. Create security roles for row level security.
4. 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

1. Create a field with the different formatting if not available.
2. Format field.
3. Add original field and newly formatted field as field parameters.
4. Add fields to visual.
5. 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

1. Add filter buttons to page
2. 4 Buttons: 2 selected buttons and 2 unselected buttons
3. Add field parameter to slicer
4. Add new column to field parameter by editing the DAX code as shown in video.
5. Create title slicer for the new column field.
6. Add title measure to the slicer title.
7. Add field parameter filter to filter pane and select a field.
8. Go to slicer and select show field values.
9. Add field parameter and measures to visual.
10. Hide and show objects for the first filter scenario.
11. Add bookmark.
12. Repeat for the second filter scenario and change filter value in filter pane for the field parameter.

Hierarchy

1. Go to field parameter table DAX and add columns as show in the video.
2. Create 3 levels: level 1 = field category, level 2 = field title, level 3 = show values for field parameter.
3. Add the field parameter table fields in the right order to the slicer and to the visual.

Self-Service

1. Create a measure called “none” and make it equal blank.
2. Create column field parameters, add none measure to the top of the list.
3. Create rows field parameters.
4. Create measures parameters.
5. Add field parameters to slice and to visual.

Conditional Formatting

1. Add field parameter measures to slice and visual.
2. In visual formatting click on cell elements.
3. Select each measure from the drop down and add conditional formatting.

Credit: PowerÆgg | Nadim