Choose which line(s) to display in a Line and Column Chart

[darentengmfs]

Hello,

Is it possible to add a toggle/slicer (without using bookmarks) to allow users to include or exclude certain lines in a Line and Column Chart?

Would like to allow users to easily include or exclude any of the 3 listed fields from Line y-axis. For example, users can select B and D, and the chart would display A B D.

Thanks in advance!

[OwenAuger · Accepted solution]

Hi @darentengmfs 

A field parameter for the line measures would be a convenient way of handling this.

1. Create a field parameter containing the measures available for selection as lines (B-D in your example).

2. Place the field parameter column in the "Line y-axis" field well.

3. Add a slicer for the field parameter (if not already added).

If you need to allow "no selection" for the line measures, you could do something similar to the method described here.

Are you able to get this working? Please post back if needed 🙂

regards