Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi,
I have a stacked bar chart where I want to apply conditional formatting. The y-axis is 'Job Name' and the x-axis has all numeric columns that are showing the number of days. I want to apply conditional formatting of these number of days columns.
For example, if 'opened - sent' <12 then the bar color should be green otherwise red.
If 'Sent - 1st interview' < 5 then green otherwise red.
If '1st - 2nd interview' < 5 then green otherwise red and so on...
Kindly check the attached image to get a clear picture of my requirements. Any help/suggestion will be appreciated.
Thank You
Hey @Bilal_Niazi123 ,
you can not achieve what you are looking for, because currently the default visuals are not supporting conditional formatting when multiple values are used in the bucket list or when a categorical variable is used in bucket list.
Next to that, there will be a problem with the legend (even if you do not show the legend), how do you imagine a legend when one jobname is green and one jobname is red?
You can only achieve what you are looking for by using Deneb: https://deneb-viz.github.io/
Hopefully, this provides some insights to get you started.
Regards,
Tom
Hi @TomMartens ,
Thanks for your response. Unfortunately, the Deneb bar chart is not allowing me to use more than one field on a column. Is it possible with hard code?
Help please if you think it is the only solution of my requirements.
Thanks
User | Count |
---|---|
72 | |
66 | |
34 | |
25 | |
22 |
User | Count |
---|---|
96 | |
94 | |
59 | |
45 | |
42 |