Power BI Conditional Formatting and Sparklines | @efficiency365
Ғылым және технология
Use Conditional Formatting in #powerbi to make it easier to understand reports. Use data bars, icons, colours and more. Create amazing #dashboard
Download sample files
efficiency365.com/wp-content/...
Contents 📚
00:00 - Intro
00:25 - Base report
00:56 - Add Conditional formatting
02:03 - Choosing the right colors
02:15 - Using Icons
04:09 - Change alignment of icons
04:30 - Show only Icon
05:19 - Data Bars and Icons
06:11 - Bad Data bars
07:09 - Background Color Scale
08:42 - Using Sparklines
Related videos 📺
Calculate MoM growth - period variance using Power BI DAX - • Calculate MoM growth -...
Create interactive catalogue using Power BI Card Browser visual - • Create interactive cat...
Power BI Visuals - Best Practices | Get The Most Out Of Your Dashboard - • Power BI Visuals - Bes...
Change These Power BI Settings Today! - • Change These Power BI ...
Everything About Conditional formatting in MS Excel - • Everything About Condi...
Buy Dr Nitin's latest book
-----------------------------------------
Efficiency Best Practices for Microsoft 365
130 best practices everyone must know
Work Smarter, Grow Faster
s.efficiency365.com/bk
Dr Nitin Paranjape is the pioneer in maximizing work efficiency in a modern work scenario.
Dr Nitin's Office Masterclass
----------------------------------------------
hi.switchy.io/mms
Online Courses by Dr Nitin Paranjape
--------------------------------------------------------------
Pivot Table Advanced - s.efficiency365.com/ptyt
Excel to Power BI - swiy.io/uxlpbi
Learn more from 1000+ blog articles by Dr Nitin Paranjape
Efficiency 365 blog: efficiency365.com/blog
LinkedIn : / nitinparanjape
Twitter : / drnitinp
Production
--------------------
Music and Effects: elements.envato.com/
Created using Adobe Premiere: www.adobe.com/in/creativeclou...
AI based captions: videoindexer.ai (Microsoft service)
Пікірлер: 7
Many thanks ❤
Great job. Many thanks to you.
@efficiency365
14 күн бұрын
Thanks @tinaflemons263 Check out my popular Excel videos How to enter and edit Excel Formulas - Back to Basics - kzread.info/dash/bejne/pKh4zrGLfNDQnKg.html Excel Green Marks - Error Checking - Best Practices - kzread.info/dash/bejne/ipmA1s6zlJzSgrw.html Excel Best Practices - Part 1 of 3 - Data Management - kzread.info/dash/bejne/pKaTk8qaZsqcnMY.html Excel Best Practices - Part 2 of 3 - Formulas - kzread.info/dash/bejne/na6T3KOvfay0cc4.html Excel Best Practices - Part 3 of 3 - Analytics - kzread.info/dash/bejne/fIKGl9uxj7PNZKQ.html 10 Excel Settings You Must CHANGE! - kzread.info/dash/bejne/qIym1Lqde9ywds4.html Automatic data clean up with Excel Flash Fill - kzread.info/dash/bejne/gGekwdqYnLu6j8Y.html Instant Excel Audit, Comparison and Analysis - Inquire - kzread.info/dash/bejne/lXiY2LeTqLK7mdY.html Six powerful Excel Navigation Shortcuts - kzread.info/dash/bejne/lIZh26-bd7PXZZM.html Handle millions of rows in Excel - Slow to fast - kzread.info/dash/bejne/a2ecmdSLo6-sZ7w.html Convert crosstab to tabular - Unpivot - Excel Power Query - kzread.info/dash/bejne/n4iosdaTeJDUfrA.html Cheers. Doc
Thanks you!
@efficiency365
14 күн бұрын
Thanks @jessykiriyanthan2597 Check out my popular Excel videos How to enter and edit Excel Formulas - Back to Basics - kzread.info/dash/bejne/pKh4zrGLfNDQnKg.html Excel Green Marks - Error Checking - Best Practices - kzread.info/dash/bejne/ipmA1s6zlJzSgrw.html Excel Best Practices - Part 1 of 3 - Data Management - kzread.info/dash/bejne/pKaTk8qaZsqcnMY.html Excel Best Practices - Part 2 of 3 - Formulas - kzread.info/dash/bejne/na6T3KOvfay0cc4.html Excel Best Practices - Part 3 of 3 - Analytics - kzread.info/dash/bejne/fIKGl9uxj7PNZKQ.html 10 Excel Settings You Must CHANGE! - kzread.info/dash/bejne/qIym1Lqde9ywds4.html Automatic data clean up with Excel Flash Fill - kzread.info/dash/bejne/gGekwdqYnLu6j8Y.html Instant Excel Audit, Comparison and Analysis - Inquire - kzread.info/dash/bejne/lXiY2LeTqLK7mdY.html Six powerful Excel Navigation Shortcuts - kzread.info/dash/bejne/lIZh26-bd7PXZZM.html Handle millions of rows in Excel - Slow to fast - kzread.info/dash/bejne/a2ecmdSLo6-sZ7w.html Convert crosstab to tabular - Unpivot - Excel Power Query - kzread.info/dash/bejne/n4iosdaTeJDUfrA.html Cheers. Doc
Hi Sir, Please full tutorial on Visualization & Dax
@efficiency365
14 күн бұрын
Thanks @prashantpavar8303 Will work on it. Check out my popular Excel videos How to enter and edit Excel Formulas - Back to Basics - kzread.info/dash/bejne/pKh4zrGLfNDQnKg.html Excel Green Marks - Error Checking - Best Practices - kzread.info/dash/bejne/ipmA1s6zlJzSgrw.html Excel Best Practices - Part 1 of 3 - Data Management - kzread.info/dash/bejne/pKaTk8qaZsqcnMY.html Excel Best Practices - Part 2 of 3 - Formulas - kzread.info/dash/bejne/na6T3KOvfay0cc4.html Excel Best Practices - Part 3 of 3 - Analytics - kzread.info/dash/bejne/fIKGl9uxj7PNZKQ.html 10 Excel Settings You Must CHANGE! - kzread.info/dash/bejne/qIym1Lqde9ywds4.html Automatic data clean up with Excel Flash Fill - kzread.info/dash/bejne/gGekwdqYnLu6j8Y.html Instant Excel Audit, Comparison and Analysis - Inquire - kzread.info/dash/bejne/lXiY2LeTqLK7mdY.html Six powerful Excel Navigation Shortcuts - kzread.info/dash/bejne/lIZh26-bd7PXZZM.html Handle millions of rows in Excel - Slow to fast - kzread.info/dash/bejne/a2ecmdSLo6-sZ7w.html Convert crosstab to tabular - Unpivot - Excel Power Query - kzread.info/dash/bejne/n4iosdaTeJDUfrA.html Cheers. Doc