Stack chart

[Oros]

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 top), and those who achieved less than 100% of their individual targets (would show in red in the bottom).  Thanks.  

[Anonymous · Accepted solution]

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. 

[Oros]

Thank you @Anonymous !!!

[grandtotal]

What is on the X axis? Every salesperson?

[Oros]

Hi @grandtotal,

Correct.  Each Salesperson is on the X axis.  Thanks.