cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helper I
Helper I

Unable to perform conditional formatting in bar graph

Hello
I have PowerBI Pro License and I am trying to put conditional formatting in the bar graph. I have created a measure for the color. However, I am not able to find three dots in the color section (which we used to pick conditional formatting rules) .. I am not sure what's the reason ?

I have latest version Power BI desktop and also tried to edit PowerBI Web version..

 
 

 

12 REPLIES 12
Community Support
Community Support

Hi @RaghavendraSA ,

 

The link you showed is invalid. You may upload the sample pbix to OneDrive (you can find it in following location) and post the link here. Do mask sensitive data before uploading.

Onedrive.png

 

 

 

 

 

 

 

 

Best Regards,

Amy 

Super User IV
Super User IV

@RaghavendraSA , there is fx sign near to color. But that you will only get when you are not using legend.

 

Data Color Fx Bar.png



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

Hello,

 

I am not sure how to share the screen-shot however I am not able to find that function .... I have the legends added but still don't see..

@RaghavendraSA , With legends you will not get that. Remove Legend/s and check. On the Text area there in option to upload an image. If not you can upload at onedrive or dropbox and share the link.



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

Got it, its working. However, I need to represent my datawith legends. For ex Industry & Monthwise performance. Last 3 months Performance missing target in Red and Green color when meeting target. How should i represent my data without using legends ?

@RaghavendraSA , Once you more than one measure then also the option will go away. But you can hardcoded colors.

 

If you can use a matrix. Then You can use it from complex cases.

 

A measure like this with "Field values" option in condition formatting (But in Matrix)

color =
switch ( true(),
FIRSTNONBLANK('Table'[commodity],"NA") ="commodity1" && sum('Table'[Value]) >500,"lightgreen",
FIRSTNONBLANK('Table'[commodity],"NA") ="commodity2" && sum('Table'[Value]) >1000,"lightgreen",
// Add more conditions
"red"
)



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

Here is attached .. I am trying to split color bases on performance (Red, Yellow, Green) instead of using multiple colors based on Industry .. How should I reach with email id to share screen-shot?

@RaghavendraSA , Did not find any link or attachment.



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

I just want three color based on performance (Red, Green and Yellow).. I have created measure which gives color combinations.

@RaghavendraSA , I am still not able to access what you shared



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

Here is attached .. I am trying to split color bases on performance (Red, Yellow, Green) instead of using multiple colors based on Industry .. 

C:\Users\rsa2\OneDrive - DXC Production\Reports\1 - CBA\Reports\SCS\Monthly\2020\03_Mar 2020\Capture...  

Helpful resources

Announcements
secondImage

Happy New Year from Power BI

This is a must watch for a message from Power BI!

December Update

Check it Out!

Click here to read more about the December 2020 Updates!

Community Blog

Check it Out!

Click here to read the latest blog and learn more about contributing to the Power BI blog!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors
Top Kudoed Authors