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!