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..
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.
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.
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)
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
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?
Here is attached .. I am trying to split color bases on performance (Red, Yellow, Green) instead of using multiple colors based on Industry ..
This is a must watch for a message from Power BI!
Click here to read more about the December 2020 Updates!
Click here to read the latest blog and learn more about contributing to the Power BI blog!
Mark your calendars and join us for our next Power BI Dev Camp!.