Skip to Content

Webi 4.1 Hide/display a specific serie of data in a line chart?

Hi,

Is it possible to hide or display a specific curve on a line chart?

Let say for example I want to show only the blue curve, is there a way to hide the green one?

I tried with an input control but it doesn't work as the measure is calculated and when it filters it changes the calculation. Is there a way to select directly on the graph which lines to display?

Thank you for your help!

Marc

a.png (16.4 kB)
Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Posted on Jun 04, 2019 at 05:06 PM

    Hi Marco,

    You can achieve this with some imagination using Input Controls. In my example below I am showing League Positions and Points by Season with an Input Control to choose between showing both Positions and Points, Positions only, or Points only. The original objects used in the report are:

    • [League Level] to show whether the team played in the first, second or third division during a season,
    • [PTS] to show the points accumulated in a season,
    • and [Season].

    Follow and apply these steps:

    1. Create a new variable [Show and Hide] =1 This variable will be used for the construction of the Input Control and the other two variables we need
    2. Create a measure variable [League] =[League Level] Where([Show and Hide] InList(1;2))
    3. Create another measure variable [Points] =[PTS] Where([Show and Hide] InList(1;3))
    4. Now, create your Input Control. I called mine "Select Graph Options" with the description "Select one of the three options to show:1 - League Position and Points by Season2 - League Position by Season3 - Points by Season" for the tooltip, a custom LOV (values 1, 2 and 3), and a default value 1.
    5. Next, right-click your graph, select Assign Data and replace your [League Level] and [PTS] with their corresponding [League] and [Points] measure objects, respectively.
    6. Now, go to Format Chart / Title and select manual Label Mode with the following formula =If([Show and Hide]=1) Then "1 - League Position and Points by Season" ElseIf([Show and Hide]=2) Then "1 - League Position by Season" ElseIf([Show and Hide]=3) Then "1 - Points by Season"
    7. Also, in Format Chart go to Value Axis and set minimum and maximum fixed values, i.e. in my example "0" and "50" respectively.
    8. Confirm with "OK"
    9. Select 1, 2 or 3 in the Input Control and see how only one or both of the data series gets displayed:

    Kind regards,

    Tom


    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jun 28, 2019 at 09:24 AM

    Hello !

    Thank you for you help and really detailed explanations!

    It worked perfectly !!

    Thanks!

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.