Customized Bar Chart Using a Matrix Visual + Conditional Formatting?!

Video by: Reid Havens & Gustaw Dudek

Learn how to create a customized bar chart (styled) visual with formatted totals using a native matrix visual in Power BI. This technique will leverage conditional formatting and DAX to reveal the hidden gems of the matrix visual!

GUEST BIO 👤

Gustaw Dudek works as Head of Business Intelligence at the Polish Company (Enterium). He has multiple years of experience in the field of data analytics and business intelligence. In addition he's one of the resident Enterprise DNA Experts, having created multiple showcase reports for various EDNA contests. Despite of designing most of showcase reports in dark-mode, Gustaw is a huge advocate of IBCS chart standards and really enjoys exploring both the art and science of report design.

RELATED CONTENT 🔗

Gustaw's LinkedIn
Gustaw's NovyPro

(Livestream Replay) Quick Insights & Story Telling Utilizing InfoRiver Advanced Charts - with Gopal

With Inforiver Charts all users (even end-users) can build, visualize and share actionable insights in minutes using the No-Code toolbar User Experience(UX).  Inforiver follows standards and best practices automatically for you to build high-quality visualizations without the need of any coding or DAX scripting.  

The key use cases that can be achieved using Inforiver Charts are:  

• Exploratory Analysis with comprehensive drill-down, drill-up and drill-across navigation across dimensions. Works in small multiple mode as well. 

• Story Telling and Data-point Annotations to tell compelling stories using dynamic data-level comments. Supports several options such as small-multiples, vertical text orientation, dynamic data tags, and more. 

• Multi-Measure Charts to build advanced visual layouts with your comparative and non-comparative measures with the right visualizations in 1-click. Automatic variances for Prior Year, Budget and Forecast data are calculated. 

• Advanced Small Multiples / Trellis to Analyze trends across various data categories in 1-click with highly responsive layouts and context based titles, analytics and comments.  

• Small form factor (SFF) UX design allows usage of Inforiver Charts with applications across all devices including mobiles and tablets. It also maintains an optimal data-ink ratio for all types of visualizations.  

Inforiver Charts visual is also IBCS-certified and offers few flexibility and customizations on top of IBCS Standards with Inforiver theme. This allows you to communicate and convey actionable insights visually to all users in your teams and organization.  

Rich Feature set which includes many advanced features that are frequently requested in Power BI community.  

Some of the features are:  

• Measure-driven data labels 

• 1-click Variance analysis  

• Flexible Number Formatting  

• Highlight variances between any two data points 

• 100% stacked bar with column totals 

• Stacked waterfall chart 

• Gradient Line chart 

• Dynamic axis break 

• Scale bands  

…and more 

RELATED CONTENT 🔗

InfoRiver Charts
Inforiver Charts Trial
Inforiver Charts Demo
Microsoft Announcement on buying Direct
Inforiver Charts AppSource
IBCS
Microsoft InfoRiver Blog Post
InfoRiver
Lumel

(Livestream Replay) Insights Unlocked Using Conditional Formatting in Power BI - with Pragati Jain

ABSTRACT 📝

In this session, Pragati will be showing some conditional formatting tricks in Power BI, which will change the way the visuals look and imparts insights to the users using them in the reports. We will also see a few tips/tricks to keep in mind on a regular basis to enhance visual capabilities in Power BI using the concept of conditional formatting. This will be a complete Power BI demo with one slide only.

GUEST BIO 👤

Pragati Jain is working as a Senior Consultant at Avanade in the UK and works towards generating and delivering data insights to various customers. She holds a Master’s degree in Data Science and Analytics from Royal Holloway University of London. She is skilled in various tools and technologies like Microsoft Power BI, Tableau, Microsoft Excel, Azure ML Studio, Azure Databricks, Pyspark, and SQL. She has been using Power BI for few years now and is recognized as a Superuser on the Microsoft Power BI Community. Outside work she enjoys photography, loves hiking, she is a trained Indian classical singer and has a passion for painting. She even has her Instagram page dedicated to painting.

RELATED CONTENT 🔗

Pragati's Blog
Pragati's LinkedIn
Pragati's Twitter
Pragati's Instagram
Microsoft MVP
Microsoft Power BI Community

How to Use the Magic Effects (FX) Button in Power BI!

Video by: Reid Havens

Learn you can apply some formatting magic using the effects (fx) button in Power BI Desktop. Plus discover the different data types can be applied with it.

RELATED CONTENT 🔗

Analyzing Breakdowns Between Two Categories with a Waterfall Chart