Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Line Chart with Two Fixed Values and One Dynamic

Hi all,   I'm trying to create a line chart where two of the lines are stationary, but a third changes when a specific month is chosen from a slicer. Here is the .pbix as reference.    In the 'Da...
Need Help
  • parry2k's avatar
    parry2k
    7 years ago

    Anonymous attached, also a message is added in case month selection is not valid. You can extend it from here.

parry2k's avatar
parry2k
Super User
7 years ago

Anonymous fixed months are always going to be Nov 2017 and Nov 2018?

Anonymous's avatar
Anonymous
Not applicable
7 years ago

parry2k No, they will change month-on-month. So for the report I send out in January it would be December 2018 and December 2017 and so on, These months are always the latest and earliest dates in the dataset though.

 

Thanks! 

 

Sam

  • parry2k's avatar
    parry2k
    Super User
    7 years ago

    Anonymous so to clarify, you want two line charts,

     

    one for most recent month available in dataset

    one for earliest month available in dataset

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      parry2k No, not quite. Requirements are:

       

      - Single line chart with three lines on it

      - Two of the lines are fixed, earliest and latest month's data

      - Third line can be controlled by slicer.

       

      If you take a look at the .pbix I've linked to you'll see a rough idea.

       

      Thanks!

      • parry2k's avatar
        parry2k
        Super User
        7 years ago

        Anonymous got it. only challenge i see it, if user doesn't select a month on slicer or select more than one month, it is going to show the sum of those months. How would you like to address this?

         

        Although doing min and max month line is not an issue.