hi there,
I would like to have a dynamic reference line based on selected product filter, where the reference line only be shown when the filter selection is (All).
In any other selection (either A, B or C), the reference line should be disappear or push down to zero.
3 answers
@Cm Eric
You can get your expected result with the parameter.
First, create a parameter from Product:
Then create a calculation:
IF [Product]=[Product Parameter] THEN [Volume] END
You can change the Volume to any value.
Drag that into the Detail shelf and use it in your reference line.
Check the attached workbook and let me know if it is correct
Thanks,
Said
(Please upvote all my answers and select them as the best if you found them helpful)
