Forum Discussion

Skater's avatar
Skater
Regular Visitor
1 year ago
Solved

Scenario mapping table

I need help getting a scenario mapping table to work with with a slicer. For example, scenario 1 should use all the parameters on that row. One of the parameters refers to say a list of accounts from...
  • wardy912's avatar
    wardy912
    1 year ago

    Hi Skater 

     

     Use a field parameter, really straight forward to set up and will solve your issue.

     

    From the modeling tab, select 'new parameter' then 'fields'

     

     

    You can choose any column from any table in the next section, I tend to use this to slice between calendar/fiscal calendar dates. Keep 'Add slicer' ticked to automatically add your slicer

     

    This will create a table, select your parameter from that table and add to your visual

    I hope this helps, please mark as solved if it does, thanks!

     

     

     

Mvsainathareddy's avatar
Mvsainathareddy
Advocate III
1 year ago

Hi Skater 

Yes, you can use Field Parameters in Power BI to help manage dynamic slicer behavior — especially when you want users to switch between different dimensions or measures in visuals. However, for your scenario mapping use case
Let’s break it down:
What Field Parameters Can Do
Field Parameters allow users to:
- Dynamically switch between columns or measures in visuals.
- Create slicers that control which fields are displayed.
How Field Parameters Might Help in Your Scenario
If your goal is to let users switch between different parameter groups (e.g., start year, percentage increase, chart of accounts), Field Parameters can help by:
- Creating a slicer that lets users choose which parameter to apply.
- Dynamically updating visuals based on the selected parameter.

But Field Parameters don’t inherently filter data — they control what is shown , not how it’s filtered .
Recommended Hybrid Approach
To make your scenario mapping work with slicers and Field Parameters:

1. Create a Scenario Mapping Table
Include:
- Scenario Name
- Start Year
- % Increase
- Account ID

2. Relate Account ID to Chart of Accounts Table

3. Use Field Parameters for Visual Switching
Create a Field Parameter table like:

DAX
FieldParameter = {
("Start Year", NAMEOF('ScenarioMapping'[Start Year])),
("% Increase", NAMEOF('ScenarioMapping'[% Increase])),
("Account", NAMEOF('ScenarioMapping'[Account ID]))
}

This lets users switch between parameters in visuals.

4. Use Slicers for Filtering
- Scenario slicer filters the scenario mapping table.
- Chart of accounts slicer filters the account table, which is linked to scenario mapping.