Forum Discussion

Oros's avatar
Oros
Post Prodigy
3 years ago
Solved

Stack chart

Hello.   I have a data of salespersons who have individual targets and sales for each month.  How do you show in a stack chart (or any chart/visual) who achivee 100% or more (would show green on to...
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi Oros ,

     

    Due to design, Power BI Desktop does not currently support implementing this feature, you can post your idea to Ideas so that Microsoft can make improvements to the product.

     

    I advise you to use subtraction,when the value is positive, it means that the baseline is exceeded, and when the value is nagative, it means that it is below the baseline.

     

    (1) This is my test data.  

    (2)We can create a measure.

    Measure = IF(SELECTEDVALUE('Table'[individual targets])>=1,"green","red")

    (3) We can create a calculated column.

    _individual targets = 'Table'[individual targets]-1

    (4)Set the color for the column as shown in the following image.

    (3) Then the result is as follows.

    Please note that if you place a field on legend, the color setting has no effect, which is also by design for desktop.

     

    Or you can use EXCEL to add a baseline and please refer to the following link which may be helpful to you.

    How to add horizontal benchmark/target/base line in an Excel chart? (extendoffice.com)

     

    I attach my sample below for your reference.

     

    Best Regards,

    Neeko Tang

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