Forum Discussion

obriaincian's avatar
obriaincian
Resolver I
3 years ago

Power BI - Line and clustered column chart , insert Target Line 0-128

Hi All,

 

I have a Line and clustered column chart in which I'd like to add a line too (I want to add the line in black below).

 

 

 

I tried to create a measure to do this but I had no luck 

Target Line = GENERATESERIES(0, 128, 1)
Need Help

2 Replies

  • Gowtham_Selvam's avatar
    Gowtham_Selvam
    Resolver I
    3 years ago

    Hi,

    Create a measure by using generateseries  function for  the line y axis.Then enable the secondary y axis 

    and disable the default y axis in format visual.

     If I answered your question, kindly mark it as solution.

    • obriaincian's avatar
      obriaincian
      Resolver I
      3 years ago

      Hi Gowtham_Selvam , Thank you for the solution however this doesn't solve my problem. I shuld have worded my question better. The Target line cannot be dirived from the data I have, it is defined manually so The line needs to be created independant of the data.