Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Targets Without Stacked Column Chart

Looking to put a target column in the background with actuals in the foreground on same chart. It is similar to a stacked column solution with total of the column at the top, but not quite what I need. Let's say my target is 1000 and the actual is 800. I do not want to have a stacked column chart with 800 in one series and 200 on top with 1000 as the total. It is very specific that the target has to sit in the backgorund so it looks like the actuals are "filling" it.

Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi Anonymous ,

    I created a sample pbix for you, please check whether that is what you want.

    Best Regards
    Community Support Team _ Rena Ruan
    If this post helps, then please consider Accept it as the solution to help the other members find it more.

5 Replies

  • TomMartens's avatar
    TomMartens
    Icon for Super User rankSuper User
    5 years ago

    Hey Anonymous ,

     

    I guess you are looking for a bullet chart, go to the store for custom visuals and search for bullet:

    Hopefully, this provides what you are looking for.

     

    Regards,

    Tom

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Closer, but still not what I am looking for. See below only as a column chart where the light blue is the target with a data label and the dark blue is the actual value with a data label

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Hi Anonymous ,

      I created a sample pbix for you, please check whether that is what you want.

      Best Regards
      Community Support Team _ Rena Ruan
      If this post helps, then please consider Accept it as the solution to help the other members find it more.

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        This is a great solution! Is there any way to get the Target to show a data label? For example, can 17 show for P6?

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Thank you. I was hoping to find a visual, but after searching I cannot find one. Doing it this way was my next option.