Forum Discussion
Stack chart
- Anonymous3 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.
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.
- Oros3 years agoPost Prodigy
Thank you Anonymous !!!