60+ Data & AI Announcements and Session Roundups from Microsoft’s Ignite 2021
5 Minute BI | Azure Data & AI | Learning Path | Power BI

60+ Data & AI Announcements and Session Roundups from Microsoft’s Ignite 2021

The hardest aspect of Microsoft Ignite was keeping up with all the announcements, especially this year with what seems a focus on the overall state of the enterprise and self-service analytics. This post provides a round-up to the various announcements and sessions in the Data & AI Platform, Power BI, Azure Data Factory, Azure Purview, and associated technologies.

How To: Create the missing KPI Indicator In Power BI Desktop Using Conditional Formatting (Updated)
Hands On Labs | How To | Power BI | Tutorial

How To: Create the missing KPI Indicator In Power BI Desktop Using Conditional Formatting (Updated)

Power BI lacks the ability to add KPI calculations when creating a data model in Power BI Desktop. I will show you how to get the same functionality by using the recently released feature “Conditional Formatting by a Different Field”. This will allow you to take a calculated score and have an Icon displayed for each row in your table.  A working Live Interactive Power BI Sample is attached at the bottom of this post.

How to use Data Driven Settings to Control Power BI Reports
Data Visualization | Learning | Power BI

How to use Data Driven Settings to Control Power BI Reports

It is easy to look at Power BI dashboards as static, but you can use some old school techniques to provide the ability the generate dynamic content using data-driven global settings that will be available to all your report developers. These techniques will allow your published reports to remain unchanged but allow the reports to dynamically reflect default information shown to the user, such as Current Month, Report Comments and even a time stamp of the last data source update.