Forum Discussion
Line Chart with Two Fixed Values and One Dynamic
Anonymous attached, also a message is added in case month selection is not valid. You can extend it from here.
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
Anonymous so to clarify, you want two line charts,
one for most recent month available in dataset
one for earliest month available in dataset
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!
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.
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