The distribution of various charts and other objects on a canvas is a key part of creating meaningful data visualization. For anyone coming to Power BI from Tableau, what might they expect the experience to be when designing the basic layout of a dashboard (er…”report”)? In this post, I cover some of the key differences…
Want to know more about how Python and Power BI fit together? In eight days, on December 6th, I’ll host a free webinar for BlueGranite that explores Python integration with Power BI. Learn about the landscape and see some demos! We’ll explore the UI, data prep/transformation, and some data visualization. Please sign up by clicking…
Makeover Monday this week focused on a variation of the “Big Mac Index”, where costs for various activities are compared in different cities. The original article presented data in a stacked bar graph, and the idea is to potentially look at ways to improve upon the visualization. While bar/column charts as a whole are probably…
Continuing the series on “translating” Tableau to Power BI, let’s consider Tableau’s Viz in Tooltip. The versatile Viz in Tooltip allows authors to embed content from one or more sheets into the tooltip of another visualization. When hovering over a mark, a filtered view of the tooltip appears. The rough equivalent in Power BI is the Report…
A few months ago, I started a series of posts about “translating” Tableau functionality to Power BI functionality and terminology (FIXED LOD example). Continuing that series, one of the new features in Tableau 2018.3 is the concept of Set Actions, which allows users to build interactivity between sheets on a dashboard. Andy Cotgreave wrote a…
In the recent webinar Using SVG Images in Power BI, I showcased dynamic SVG measures displayed in the Table and Matrix visuals. Both of those visuals are limited to displaying images in a small grid. I also showed SVG images stored as columns and displayed with the HTML Viewer custom visual, which allowed for a much…
While R has been available in Power BI for a few years, Python was recently added as preview functionality to Power BI Desktop. If you have done any work with Power BI’s R Script or Python Script in Power Query, you may have noticed that many scripts appear to run slower in Power BI than if…
Makeover Monday is a weekly social effort to help everyone in the data visualization community. Working primarily from data.world and tweeting with the hashtag #MakeoverMonday, this community strives to steadily improve the quality of data analysis and visualization at the individual and community level. There’s even a new book that grew out of the weekly…
Power BI now includes eight built-in themes in addition to the countless JSON variations that you could import. If you are interested in the hex color values in order to use them in Power BI or elsewhere, here is a basic quick reference to the built-in themes. I’ve only included the initial eight colors in…
What are some considerations when adapting a locally run PowerShell script that invokes web requests to Azure Automation? This post qualifies as one where I want to document steps for my own benefit after I forget in a few weeks, but it’s even better if anyone happens to be doing something similar and benefits as…
Thanks to Charles Sterling from Microsoft for giving me an opportunity to present on the Power BI YouTube channel today! A recording from the hour-long webinar Using SVG Images in Power BI is now available. Thanks for everyone who joined live and who might be interested in viewing the video about building dynamic SVG measures in…
Over the summer, a variety of BlueGranite consultants came together to write posts on pre-built AI using Microsoft Cognitive Services. As data professionals, we don’t have solutions or build apps that take advantage of every API, but certain services are extremely useful both for prototyping and long term solutions. The posts are grouped according to…
In addition to using SVG in the HTML Viewer custom visual as outlined in previous posts (Part 1, Part 2), Power BI allows you to work with SVG images as Image URLs. The following technique is available for use with any visual that renders Image URLs as an image. This puts SVG on par with…
A past post discussed different fonts available for use in Power BI, and I have also showed how to try to expand your font selection with Themes. What if users want more variety? It’s possible to add additional custom fonts using the powerful HTML Viewer custom visual. You might take advantage of this method for a…
Earlier in the year, I published template Theme files for Power BI’s visual settings. These files were not meant to be complete themes but were instead for reference in building your own themes. What happens when Microsoft introduces new Format options for a visual though? The June Power BI Desktop update provides an opportunity to…
