Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Add a constant line for 'Line & Clustered column chart' = Combo chart

I am looking for a way to add a constant line - 5% dotted line in my combo chart ' Line & Clustered column chart'  Combo chart configuration.    Chart would like this:-   Currently t...
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

Anonymous , check if you can create a measure and add a like

 

measure =.5

 

add that in the combo visual and change line style

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Had tried the measure approach as well.

    Since the primary Y axis is %, and 2nd Axis is number. (2 different unit of measurements)

    If I add a "measure 5" to my combo line chart. it will become like this:- which is not what I want.

    Black bars = 5%

    akiko_lim_0-1597852042392.png

    • DataZoe's avatar
      DataZoe
      Icon for Microsoft Employee rankMicrosoft Employee
      6 years ago

      @akiko_lim You should be able to move it to the line values:

      combo.JPG

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        Thanks DataZoe for your quick reply. very much appreciated. 

         

        If I move the 5%line to line Values, my 2nd Y-Axis UoM (unit of measure) will not be correct. 

         

        I am mixing Pecent data (5%) line with other # of Test (whole number) . My chart will not be correct. 

        See below, 2000% 

         

         

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    This is awesome, It worked perfectly Thanks