Dynamic Conditional Formatting in Power BI

#PowerBI #DAX
Hello Friends,
In this video, you will learn how to create a power bi dashboard with dynamic condition formatting. We have created to measure in Power BI using DAX to create the dynamic Conditional Formatting in Power BI. Using this measure we have put the conditional formatting on Card Background, Title, Font color and charts data colors.
Please download the practice file from below given link:
www.pk-anexcel...
Download our free Excel utility Tool and improve your productivity:
www.pk-anexcel...
See our Excel Products:
www.pk-anexcel...
Visit to learn more:
Chart and Visualizations: www.pk-anexcel...
VBA Course: www.pk-anexcel...
Download useful Templates: www.pk-anexcel...
Dashboards: www.pk-anexcel...
Watch the best info-graphics and dynamic charts from below link:
• Dynamic Graphs
Learn and free download best excel Dashboard template:
• Excel Dashboards
Learn Step by Step VBA:
• VBA Tutorial
Website:
www.PK-AnExcel...
Facebook:
/ pkanexcelexpert
Telegram:
t.me/joinchat/...
Pinterest:
/ pkanexcelexpert
Send me your queries on telegram:
@PKanExcelExpert
************ Suggested Books ********
VBA: amzn.to/2TMMikX
Excel Dashboard: amzn.to/2WZi2Fj
Power Query: amzn.to/2Ibd7xR
Power Pivot and Power BI: amzn.to/2DCg8BB
Exam Ref 70-778 (Power BI): amzn.to/2GnWYTN
************ My Stuff ***************
Mic : amzn.to/2TLnF88
Video Editor: screencast-o-m...

[@shoryaarora1464]

You are king of beautiful Dashboard. I like your every video. Thank you

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@fullofenergy306]

Indeed. He's a creative mind to develop dashboards in Excel. I have never seen someone really expert like him him in creating magnificent dashboards

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@iancoify]

You're a life saver! Thanks for this

[@PKAnExcelExpert]

Thanks for your valuable feedback🙏

[@ahmedal-dossary4386]

I have a question. If I’m plotting actual against plan for instance and using the conditional formatting feature. Legend color doesn’t change with conditional formatting. How to take this into account?

[@ruirodrigues5292]

This is so simple and so amazing!!! Thank you!!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@fawziyahkoiki3076]

thank you so much for this!

[@PKAnExcelExpert]

You're so welcome!

[@akashvarma6822]

Is there any full power bi classes ?????

[@sudippandit1]

Excellent! Thank you sir. I hope more videos are coming soon, Take care

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@totvabe1]

Wonderful video, PK! I need more videos with Power BI, Excel is easier.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@rochellerobinson939]

This is really good of course. However, I noticed the the Total Sales card is different on the sample. How do you get the Target Sales to show up as well?

[@salahmed4877]

This is absolutely brilliant!!! Thank you so much

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@peterward79]

Very helpful tutorial, many thanks.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@williamnajar5521]

Thank you, I like your solution.

[@andrewscotttt]

Great video - extremely helpful.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@Srikanth_Rajapuram]

Thank you for good presentation 👍

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@marilyngoldman1346]

This is so helpful! Thank you!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@deb73268]

can you please tell me how do we move reports from development to test and production in real time in power BI .Which tool do we use ?Recent one and in past too

[@Haniii98]

Thanks! It's exactly what I was looking for :)

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@gauravghosh8002]

Awesome Video Sir , it's very helpful for me , just a query can we create the same Dynamic conditional formatting in LIVE Data ?

[@sanhitadas4128]

Hi PK , do you have any video on kpi indicator in power bi

[@ferD8524]

Greate job, !!Master!!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@romabisht8389]

hi, thanks for the video. I have a query- Suppose I have a dataset in which I have 4 Averages (Average 3, 5, 7 and ALL years) which I have calculated within Power BI using measures. Now my colour coding should be based on the averages that I select. So suppose my data point is 10% and the Average 3 years is 12%. so my ranges will be +-5% for example (which can again vary to be between 1%-20%). So my ranges are 12%+5% = 17%(High Range) and 12%-5% = 7% (Low Range). So my point lies between this range so it should be green but if suppose my data point would have been 18%, then it would have been out of range and thus should be red. How can I make it work? I need to calculate these high and Low ranges in Power B itself which will be dynamic and will depend on the Average chosen. Thanks

[@romabisht8389]

this conditional formatting should be in a line chart

[@saikumar-uu8ze]

how to apply conditional formatting for clustered column line chart?

[@DilipTiwariVlogs]

Awesome Bro! Very helpful. Thanks!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@freakzisback]

Thank you

[@PKAnExcelExpert]

Welcome

[@GarimaSaini01]

i am not able to understand that why your videos are under Views, You are too good i wish if could work with you :)

[@narapat100]

Yes dear u r correct he is too good, but u r the best and even I wish if I could work with u... 😎

[@ahmedal-dossary4386]

Awesome! Thanks for sharing.

[@deb73268]

Very nice

[@PKAnExcelExpert]

Thanks

[@diallomamadousaidou2745]

Thanks PK. You are the best, sure thing. How did you deploy this report on a web version ?

[@pravinupadhyay2046]

Embedded code can be generated from the PBI service which you can use if you want this to deploy on your web portal

[@fullofenergy306]

Brother can you please help me to figure out how can I skip certain cells while using arrow keys. For example there are formulas in cells ranging from A2 - A5, so once I'm in cell A1 and when I move down using arrow key it skip all those cells that contains formula and take me directly to cell A6 in one key press

[@saurabhrai5798]

You may be pressing ctrl + navigation key which may be affecting it and skipping the cells in between. Try pressing the navigation only without using the ctrl button and it should be fine. Alternatively you can also press the ctrl + g on your keyboard and enter the cell number which you want to access and it will directly take you there. Hope it helps.

[@rahulshiroor3739]

Sir,. I like your videos and the way you explain it.. I have a problem in BI and need your help to solve it, I need help in dynamic grouping, I have a query where sales team has achieved their target and it varies from 0 to 200%, I want to slice it based on the criteria below 50%, 50-100% and above 100%, I should be able to give a slicer for these 3 conditions.. when I click on below 50% only those sales team should get displayed. Its my request from heart..!"

[@pravinupadhyay2046]

You need to add a calculated column in your data table, using few IF and AND function to create group slabs, these formula will be same like excel only it will take column reference. Then put this column into slicer Slab= If( table[performance]0.5,table[performance]

[@anupamshukla2346]

Great!!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@rahulshiroor3739]

As mentioned in my last comment, I have a contribution% measure but I am not able to display only 80% contributing brands in a group and 20% contributing brands 80/20 ..

[@pravinupadhyay2046]

You can search for ABC Pareto analysis in DAX ,it needs few calculated columns to be created,