PBI OKVIZ bullet chart how to make -ve Bar change to Red color ?

[admin11]

[v-deddai1-msft · Accepted solution]

Hi @admin11 ,

There is no such option for the custom visual. I suggest you use clustered bar chart. You can create a measure like:

measure = IF([Your measure]<0,"Red","Blue")

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

Best Regards,

Dedmon Dai

[admin11]

@v-deddai1-msft 

https://community.powerbi.com/t5/Desktop/How-to-make-P-amp-L-INDEX-3-10-12-don-t-appear/m-p/1666163#...

Kindly help to take a look at above post on PnL

[admin11]

@v-deddai1-msft 

WOW , i am surprise with your knowledge on PBI. Thank you very much.

[amitchandak]

@admin11 , I can only see a conditional formatting option for background and fond color, not for data color.

In Data color, you can change the color of each value(measure)

[admin11]

@amitchandak 

Thank you for sharing , Data colour only can set the color of the bar , it does not allow user to insert expression for dynamic control the colour,

Paul

[amitchandak]

@admin11 , I was checking that option. Do not saw one