4.6 How to Apply Conditional Formatting in Matrix in Power BI | Power BI Tutorials for Beginners

#pavanlalwani #powerbi #dashboarddesign #dataanalytics

In this video, we will explore the process of working with conditional formatting in matrix charts in Power BI. Conditional formatting is similar to what we have previously seen in tables, but now we will see how it functions in matrices. By following along with the demonstration, you will learn how to apply conditional formatting to matrices, creating data bars for each section. Additionally, you will discover how to sort columns based on ascending or descending order, allowing you to identify the maximum sales in each region. There is also an option to customize the color and appearance of the data bars using the advanced control button. This enables you to make changes to the color scheme, making it easier to interpret positive and negative profits. Furthermore, we will explain how to disable the values behind the bars if desired, leaving only the bars visible. Finally, we will briefly touch on using icons to represent different performance levels in matrices. By the end of this tutorial, you will have a clear understanding of how conditional formatting works in matrix charts in Power BI, which can aid in the analysis and visualization of your data.
---------------------------------------------------------
💼 Invest in your future with our Power BI 2023 NEW Course at an incredible 50% discount:

📚 200+ MCQs to test your knowledge.
📝 20+ Assignments for hands-on practice.
🔍 11+ Case Studies for real-world insights.
💼 5+ Industry Projects to build your portfolio.
🎓 Course Completion Certificate for your resume.
💡 Tips & Tricks to boost your skills.
🔎 5+ Industry Datasets for practical learning.

Join thousands of professionals who have transformed their careers. Enroll now at 50% off!
You can also explore our Power BI DAX 2023 course and get a 360º understanding of DAX

Invest in yourself. Become a Power BI expert. The future is yours! 💼💪"

#datacleaning #businessintelligence #powerbi #powerbitraining #microsoftpowerbi
---------------------------------------------------------
Timestamps:
00:00:03 Conditional Formatting in Matrix 📊
00:00:24 Applying Data Bars 📈
00:00:52 Sorting based on Total ▲▼
00:01:22 Changing Colors for Positive and Negative Profits 🌈
00:01:52 Differentiating Profitable and Unprofitable Items ✅❌
00:02:21 Disabling Values, Show Only Bars 📊
00:02:50 Using Icons for Visual Representation 🖼️
00:03:19 KPIs and Key Performance Indicators 🔑✨

[PavanLalwani]

🚀 Calling all data enthusiasts! 💼🌟

👉 Discover the power of Power BI with our Specialization course at a jaw-dropping 50% off!


💥 Level up your analytical game and supercharge your career with the Power BI DAX course. 💯💼

[shajidhasultan]

Hi Pawan, your videos for Power BI are amazing. I learnt Tableau through your videos.I was not able to use Conditional formatting in Tables and Matrix too. Please advise.

[sauravchaudhary]

great learning from your videos.. i would like to understand more deep into My SQL

[sumitgoyal]

Hi sir, In the latest update the Conditional formatting option is not there in the Format Visuals list. Please tell me where to find it...👍🏽

[akash]

Hi Pavan, Can i know if there is any possibility that we can add conditional formatting to a column instead of values.. Here in this case phones have highest sales so i need to provide green color, supplies i need to give red color. Let me know if it is possible.. thanks you..

[preetisrivastava]

Why I can't see the option advance control

[PanBan]

Can I add Conditional formatting based on Row Header, Column Header & Value (combination of all 3).
Example I want to format if 1)region is East, 2) Sub-Category is Art, 3) Value is less than 1000

[PranayPawar]

What if I want to apply conditional formatting on Sub Category Column...?

[hailelove]

dear I love your lesson. but in my power BI I don't see conditional formatting I don't know why

[jainismbyshaivishah]

Hi Pavan, I want to apply conditional formatting based of column value with range. e.g. in Central if value between 1 to 10000 then red and 10000 to 15000 then green, in East value between 1 to 2000 then red and 2000 to 5000 with yellow and >5000 then green. this require because some time new state launch and criteria are diffrent please guide how to do the same.

[navimech]

Hi Pavan,
I am not able to work on power BI as I am facing some issue .Getting error message ' we weren't able to connect to the model'. Please help on this

[shobhitbahuguna]

in my version i am not getting conditional formatting in drop-down
can you please suggest me where I can get that

[naveeng]

Hi Sir,
Can i know, in the fields area next to order date and ship date it showing symbols i'm notable find, how will get that in my powerbi plz
Many Thanks
Naveen

[GrowingChildren-HindiEng-uhsj]

i could not find conditional formatting in the format option.

[MrPranaysawant]

where I can find Field Pane in new Power BI version? Its Feb 2023 release.

[amanprasad]

there is no advanced control in data bars. what to do now?

[amritathakur]

sir I m unable to find practice file how can I download this for free