Forum Discussion

admin11's avatar
admin11
Memorable Member
5 years ago
Solved

How to insert Target Vari % on my Sales Vs Target GAP chart ?

Hi All

My sales vs target chart now only can display sales and target amount. 

I like to add vari % on the chart . by create a marker . So that i can see the % vari on very month.

https://www.dropbox.com/s/teq9clgobgnulvt/PBT_V2021_400%20TS_SI%20SAMPLE.pbix?dl=0

 

Paul

  • admin11 

    When you add the measure to the Line chart, it is displaying but because the scale of the Y axis is too big then you see a constant line...Example if you change the start and end you see the measure displaying like you want

     

    A work around could like putting 2 Line charts on top of each others and with little adjustements you can get a view like this

    Or you can use a different visual

     

     

     

     

     

2 Replies

  • aj1973's avatar
    aj1973
    Community Champion

    admin11 

    When you add the measure to the Line chart, it is displaying but because the scale of the Y axis is too big then you see a constant line...Example if you change the start and end you see the measure displaying like you want

     

    A work around could like putting 2 Line charts on top of each others and with little adjustements you can get a view like this

    Or you can use a different visual

     

     

     

     

     

    • admin11's avatar
      admin11
      Memorable Member

      aj1973 

      Thank you very much for your help. i like the bar chart you manage to add the target vari. which is what i need.