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

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

Power BI Parameter Error – Invalid URI: The hostname could not be parsed

Today I encountered an issue in Power BI where a user was building a dashboard from a template I had created. The template has a single parameter, which is the full path to the exported .csv file. Several people have successfully used the template, but one user kept hitting the following error. DataFormat.Error: Invalid URI:…

3

Power BI 12 Days of Dashboards – Day 12 – Crazy Christmas Dashboard

Day #12 – Crazy Christmas Dashboard As part of my Power BI 12 Days of Dashboards series, day #12 brings this big project to a close with a Christmas Dashboard socked full of a few new tricks I learned throughout the creation of the blog series. In the customer environments that I support, I don’t…

4

Power BI 12 Days of Dashboards – Day 11 – NFL Football Touchdown Dashboard

Day #11 – NFL Football Touchdown Dashboard As part of my Power BI 12 Days of Dashboards series, I’m spending day #11 exploring NFL Football stats from www.pro-football-reference.com. As a huge sports fan, I love the data that Sports Reference provides and use it often for Power BI demos. The Power BI Dashboard uses the…

4

Power BI 12 Days of Dashboards – Day 10 – Exploring Twitter Data

I Day #10 – Exploring Twitter Data As part of my Power BI 12 Days of Dashboards series, day #10 explores Twitter data with four different interactive dashboards. I’ve had a Twitter account for a few years, but have only started to use it regularly over the past 6-8 months. I presented at a conference…

0

Power BI 12 Days of Dashboards – Day 9 – Building your first SCCM Report in Power BI

Day #9 – Building your first SCCM ConfigMgr Report in Power BI As part of my Power BI 12 Days of Dashboards series, day #9 will take a slight twist to the current format and help walk you through creating your first Power BI report leveraging data from System Center Configuration Manager (SCCM). I’ve also…

2