Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Field Parameter composite key error?

I'm facing an issue in Power BI after creating a field parameter to swap between 4 hierarchy columns with person names in them. The user should be able to select hierarchy level in slicer, and then, ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi Anonymous ,

 

Try to modify your formula like below:

Hierarchy Swap Test = 
VAR selectedRole = MAX(hierarchy_parameter_test[Parameter])
RETURN
SWITCH(
    selectedRole,
    "VP_NAME", MAX('TABLE'[VP_NAME]),
    "DIRECTOR_NAME", MAX('TABLE'[DIRECTOR_NAME]),
    "MANAGER_NAME", MAX('TABLE'[MANAGER_NAME]),
    "SUPERVISOR_NAME", MAX('TABLE'[SUPERVISOR_NAME])
)

 

Best Regards,
Adamk Kong

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Anonymous this only returns 1 value, my intention is for it to pick an entire column of values. So user picks slicer value 1: Column 1. Slicer value 2: column 2 and so on. Using MAX only returns 1 value, not the entire list of associated values