topic Re: Scenario mapping table in DAX Commands and Tips

Scenario mapping table

Skater — Fri, 22 Aug 2025 10:22:08 GMT

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 the chart of accounts. The specific scenario 1 chart of accounts is slicer wher the user can select the accounts within that scenario 1 to impact with the other parameters with that scenario say start date and percentage increase all users selectinons for parameter 1 group. My issue is that there the chart of accounts is in the slicer but the scenario table only refer to the table name that contains the chart of account table. I've set separate tables for the parameter percentage, start year and chart of accounts single column which I'm using all as single select slicers except for the chart of accounts as a multi select. Any suggestions?

Re: Scenario mapping table

Mvsainathareddy — Fri, 22 Aug 2025 11:33:52 GMT

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.

Re: Scenario mapping table

wardy912 — Fri, 22 Aug 2025 13:12:37 GMT

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!

Re: Scenario mapping table

Skater — Sun, 24 Aug 2025 00:13:22 GMT

Thanks a I'll work through a solution and let you know how it goes.

Re: Scenario mapping table

Skater — Sun, 24 Aug 2025 00:14:21 GMT

Thanks a I'll work through a solution and let you know how it goes.

Re: Scenario mapping table

Anonymous — Tue, 26 Aug 2025 04:47:22 GMT

Hi Skater ,

Thank you for reaching out to the Microsoft fabric community forum.

Could you please confirm if the issue has been resolved. I wanted to check if you had the opportunity to review the information provided by wardy912 and Mvsainathareddy helpful for you to resolve your issue. Please feel free to contact us if you have any further questions.

Thnak you.

Re: Scenario mapping table

Anonymous — Thu, 28 Aug 2025 09:27:25 GMT

Hi Skater ,

Could you please confirm if the issue has been resolved. Please feel free to contact us if you have any further questions.

Thank you.

Re: Scenario mapping table

Anonymous — Mon, 01 Sep 2025 04:03:09 GMT

Hi Skater ,

We haven’t received an update from you in some time. Could you please let us know if the issue has been resolved?
If you still require support, please let us know, we are happy to assist you.

Thank you.