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 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.

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi parry2k,

 

These are good questions! Dependent on how things are setup you could specify only single selection on the slicer (if the MIN / MAX dates are elsewhere) - or the other option would be to have some message telling the user that they appear to have selected more than one option (could be based on counting selections, or have a threshold that triggers the message).

 

Sorry, a bit vague!

 

Sam

  • parry2k's avatar
    parry2k
    Super User
    7 years ago

    Anonymous are you ok to build that logic or you need assistance with that too.

    • parry2k's avatar
      parry2k
      Super User
      7 years ago

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

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        Thank you parry2k - that was exactly what I was after! Much appreciated :smileyhappy: