Hi everyone, my requirement was to plot three different measures in only one line chart and to show/hide them with a checkbox. I really can't do this, can you help me?
Hello,
You can make a line chart with three 3 measures, but toggling the measures is not really possible as far as I know.
One workaround is to restructure your data .
From:
A | B | C |
1 | 2 | 3 |
4 | 5 | 6 |
To:
Group | Value |
A | 1 |
A | 4 |
B | 2 |
B | 5 |
C | 3 |
C | 6 |
If you do that, then you can create a List control with the Group values and assign the Group variable to the Group role of the line chart.
Sam
Hello,
You can make a line chart with three 3 measures, but toggling the measures is not really possible as far as I know.
One workaround is to restructure your data .
From:
A | B | C |
1 | 2 | 3 |
4 | 5 | 6 |
To:
Group | Value |
A | 1 |
A | 4 |
B | 2 |
B | 5 |
C | 3 |
C | 6 |
If you do that, then you can create a List control with the Group values and assign the Group variable to the Group role of the line chart.
Sam
Registration is now open for SAS Innovate 2025 , our biggest and most exciting global event of the year! Join us in Orlando, FL, May 6-9.
Sign up by Dec. 31 to get the 2024 rate of just $495.
Register now!
See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.
Find more tutorials on the SAS Users YouTube channel.