Add constant lines to small multiples

Hi HANA7B ,

You cannot add dynamic constant lines directly with smal multiples you can however make error bar that can match this.

Try the following steps:

• Select a column and line chart
• Create the following measure:

Constant = 
  SWITCH(TRUE(),
       SELECTEDVALUE( Products[Class]) = "H" && SELECTEDVALUE('Calendar'[day]) = 20, 1,
       SELECTEDVALUE( Products[Class]) = "L" && SELECTEDVALUE('Calendar'[day]) = 15, 1,
       SELECTEDVALUE( Products[Class]) = "M" && SELECTEDVALUE('Calendar'[day]) = 10, 1)


Upper = CALCULATE([Total Quantity], REMOVEFILTERS('Calendar'[day]))

Lower = 0

In my case the Product[Class] is the column I'm using on the small multiples and the Total Quantity is the column I'm using in my visual

• Setup of visual:
  • X-Axis: Day
  • Column Y-Axis: Total Quantity
  • Line Y-Axis: Constant
  • Small Multiples Class
  • Error Bars:
    • By Field
    • Upper Bound: Upper measure
    • Lower Bound Lower measure
    • Relationship to measure: Absolute
    • Bar: on
      • Color selet to you needs
  • Turn of lines so that the marker does no show
  • Turn off values in secondary axis

Final Result: