Adding a Continent Slicer to Power BI Reports

HOW TO: Adding a Continent Slicer to Power BI Reports After building Power BI reports for many customers over the past couple years, one thing is certain – people love maps. Nearly every organization I support operates at a global scale, with offices (or business) spanning the world. I’ve recently starting using this small trick…

0

Power BI Desktop – Terms and Definitions

Power BI Desktop – Terms and Definitions The following list of Power BI Desktop terms and definitions are intended to help users better understand the terminology used within the product and referenced in documentation and blogs. As I work on customer sites to teach, develop, and evangelize Power BI, I’ve been asked often for a…

2

Compiling a XAML-based project fails in Visual Studio with FIPS enabled

Compiling a XAML-based project fails in Visual Studio in a FIPS-enabled environment with an error message stating “This implementation is not part of the Windows Platform FIPS validated cryptographic algorithms”. Solution: This bug has been fixed in .NET 4.7.1. (which has not yet been released). Details: After publishing a recent blog entry about Visual Studio…

0

Comparing Table Styles in Power BI

Tip: Use table styles to improve the look of your table data in Power BI As I continue to work with customers who are new to Power BI, a common pattern I’m noticing is that people aren’t aware of the table style option in the format pane. The following screen shot shows the 9 different…

0

Sorting by Month Names in Power BI

How do I sort by month number instead of alphabetically by month name in Power BI? As I continue to work with customers to develop Power BI dashboards, this topic of sorting month columns comes up quite often. There are a few great threads and blog entries with instructions, but the following screenshots and steps…

0

Power BI – Using the Treemap Visual with KPI status colors (red, yellow, green)

Using the Treemap Visual with KPI status colors (red, yellow, green) “Is possible to modify the default colors of the Treemap visual to reflect red/yellow/green status based upon a status field value?” This question was asked yesterday in a customer demo, and I didn’t know the answer off the top of my head. As it…

1

Excel Add-In not displayed in ribbon due to Group Policy setting

Excel Add-In not displayed in ribbon due to Group Policy setting Problem: The Excel Solver Add-in is enabled and appears to load during startup, but is not displayed/visible in the ribbon. Solution: Update the Group Policy setting titled “Disable UI extending from documents and templates” to uncheck/disable “Disallow in Excel”. Details: Today I encountered another…

0

What is the minimum number of AlwaysOn nodes required to obtain both HA and DR?

While recently answering questions in the MSDN SQL Server forums, I came across a great question about the minimum number of nodes required to obtain both high availability (HA) and disaster recovery (DR) with AlwaysOn Availability Groups. As an on-site SQL Server engineer, this is a very typical type of question that I receive from…

0

Creating a New Project in Visual Studio fails when FIPS is enabled

While testing application compatibility on Windows 10, one of my customers encountered an issue creating a new project in Visual Studio 2015 when FIPS was enabled. A new project could be completed successfully one time, but all future attempts to create a new project failed with an error message stating “Object reference not set to…

2