Hi
I wish to change the parameter fields one of my graphs shows based on the sector selected on a separate filter on the same page.
I.e. For Sector A and B I want to show measures X, Y and Z but for Sector C I want the graph to show measures V and W
I'm sure there are workarounds with buttons and bookmarks with multiple charts but I would prefer to avoid these.
What I have tried is making a measure:
Filter =
var _selectedMeas = SELECTEDVALUE(ParameterFields[Parameter Fields])
var _SectorCSelec = IF(SELECTEDVALUE(Sector) = "Sector C", 1, 0)
var _NotSectorCSelec = IF(SELECTEDVALUE(Sector) = "Sector C", 0, 1)
return
SWITCH(
TRUE(),
_selectedMeas = Measure V, _SectorCSelec,
_selectedMeas = Measure W, _SectorCSelec,
_NotSectorCSelec
)
And then applying this as a filter to the graph, include if Filter = 1. This works as a way of sorting the slicer, e.g. if sector A is selected the only selectable measures are X, Y and Z but the selectedvalue(parameter) part does not work on the graph, the final part of the switch function is always returned so it shows all measures for sectors A and B but no measures when Sector C is selected.
Is there a change I can make such that the graph switches between these measures based on the sector selected?
Many thanks,
