Conditional Formatting based on Field Values

[Shruthiyua]

Hello Community,

I am trying to create a matrix table as shown above. My goal is to add databars based on 3 conditions.

Variance >10%: Green,
Variance<-10%: Red,
else Grey.

I am not able to find "Field Values" in Format Style. Please guide me where I have to do it right.

Thanks a lot!

Shruthi

[Praful_Potphode · Accepted solution]

Hi @Shruthiyua ,

Conditional formatting based on field value is not possible in databars .

Please follow below video by DAX Jutsu

Data bars using native visuals and SVG in Power BI 

 in this video you will find sample pbix in description which can you design your own logic.

Please give kudos or mark it as solution once confirmed.

Thanks and Regards,

Praful

[grazitti_sapna]

Hi @Shruthiyua,

Please follow the below steps:
Make sure you are using a matrix and choosing a specific column and under that conditional formatting. 

Following above steps you'll be able to see format style- fields value.

After choosing field value. Pick your meausre or column created for confitional formatting.

🌟 I hope this solution helps you unlock your Power BI potential! If you found it helpful, click 'Mark as Solution' to guide others toward the answers they need.

💡 Love the effort? Drop the kudos! Your appreciation fuels community spirit and innovation.

🎖 As a proud SuperUser and Microsoft Partner, we’re here to empower your data journey and the Power BI Community at large.

🔗 Curious to explore more? [Discover here].

Let’s keep building smarter solutions together!

[Shruthiyua]

Hi @grazitti_sapna ,

Thanks for the response!

I hope the your response checks for Background color on 'Values' in Matrix table.

I am looking to add conditional formatting for 'Values' (in this case Variance %) with Databars based on Format Style  -> Rules/Field Value.

I am able to look at Rules/Field Value for Background color, Font Color etc., but not for Databars.

Thanks,

Shruthi