Hi,
I have exisiting field parameter with slicer that works but I would to modify the dax so it will return values based on another field parameter slicer. However, I'm getting an error with the dax.
"The expression refers to multiple columns. Multiple columns cannot be converted to a scalar value."
I'm not sure if my approach is correct but I would appreciate any help please @TheoC @JoaoMarcelino
Comparative Scen3 (field param) =
VAR Comparative_Scenario_USD =
{
("Budget", NAMEOF('KPI USD'[KPI MTD Budget USD]), 0),
("Last Year", NAMEOF('KPI USD'[KPI MTD LY USD]), 1),
("2019", NAMEOF('KPI USD'[KPI MTD 2019 USD]), 2),
("Forecast", NAMEOF('KPI USD'[KPI MTD Forecast USD]), 3)
}
VAR Comparative_Scenario_LOCAL =
{
("Budget", NAMEOF('KPI'[KPI MTD Budget]), 0),
("Last Year", NAMEOF('KPI'[KPI MTD LY]), 1),
("2019", NAMEOF('KPI'[KPI MTD 2019]), 2),
("Forecast", NAMEOF('KPI'[KPI MTD Forecast]), 3)
}
RETURN
SWITCH(
SELECTEDVALUE(ParamCurrency[ParamCurrency]),
"USD", Comparative_Scenario_USD,
"LOCAL", Comparative_Scenario_LOCAL
)
@Anonymous , As of now field parameters can filter slicers of another field parameter. You can check and vote for an existing idea : https://ideas.powerbi.com/ideas/
@amitchandak - thanks for the feedback. That's a shame. I guess the alternative options could be using bookmarks or creating a table for the slicer selection and then creating measures using selected value.
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!