Forum Discussion

Shruthiyua's avatar
Shruthiyua
Regular Visitor
10 months ago
Solved

Conditional Formatting based on Field Values

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 a...
Need Help
  • Praful_Potphode's avatar
    Praful_Potphode
    10 months ago

    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's avatar
grazitti_sapna
Icon for Super User rankSuper User
10 months ago

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's avatar
    Shruthiyua
    Regular Visitor
    10 months ago

    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