Hi,
I have two fields parameters for the same measures, that enables users to compare metrics in a Line & Column chart.
Is it possible that whatever value is selected in one field parameter is removed from the other. As below.
Thanks.
Solved! Go to Solution.
Hi @Nickpw ,
Please new a measure:
Measure =
VAR __parameter1 = SELECTEDVALUE('Parameter1'[Parameter Fields])
VAR __filter = IF(MAX('Parameter2'[Parameter Fields])<>__parameter1,1)
RETURN
__filter
and apply it to the second slicer's filter:
result:
Best Regards,
Gao
Community Support Team
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data
Hi @Nickpw ,
Please new a measure:
Measure =
VAR __parameter1 = SELECTEDVALUE('Parameter1'[Parameter Fields])
VAR __filter = IF(MAX('Parameter2'[Parameter Fields])<>__parameter1,1)
RETURN
__filter
and apply it to the second slicer's filter:
result:
Best Regards,
Gao
Community Support Team
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data
Perfect, thankyou.