Forum Discussion

HR3038511's avatar
HR3038511
Helper I
2 years ago
Solved

Target Line in Stacked Bar Chart on same scale

Hi,    In my stacked bar chart I'd like to have the target line on the same scale as the bars. Currently my target line is out of scale with the bars.  The target is 100 so i want it to be on the h...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi HR3038511 ,

    I see what you mean, but with Power BI Desktop, you can manually change it depending on how many you want to join. If you want to be dynamic, you can choose the FX next to it to write it.

     

     

     

    Best Regards

    Yilong Zhou

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

HR3038511's avatar
HR3038511
Helper I
2 years ago

Anonymous The problem here is that over time there will be additional bars with values greate than 1000. So fixing the scale on the second axis won't do the job because the X axis scale might change. Any idea how to work around this?

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi HR3038511 ,

    I see what you mean, but with Power BI Desktop, you can manually change it depending on how many you want to join. If you want to be dynamic, you can choose the FX next to it to write it.

     

     

     

    Best Regards

    Yilong Zhou

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.