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…
When needed, Power BI offers the ability to create Groups and Bins to help consolidate data into a more presentable or meaningful visualization. The documentation has more detail and walks through the process of creating Groups and Bins. Looking at Bins and Groups in a Power BI model using a tool like SQL Server Management…
Last Friday, I created a prototype Power BI “Slicer pane” and posted it to social media. It generated a more positive response than I would have thought. After fulfilling a client request that afternoon to double the number of slicers, the report’s primary visuals were reduced to the bottom 2/3 of the page. In my…
In Power BI Desktop and in many other Microsoft products, the Quick Access toolbar lets you save shortcuts to different application functions. While this functionality in the “Ribbon” is nothing new, I want to stress how convenient it can be. This is particularly true for Power BI users who flip between tabs in the main…
Join Power BI in space! Power BI is holding a Space and Space Exploration Contest through March 31st. Get the details on the Community site, build a space-related report, and post it to the Data Stories Gallery. Go here for more information: https://community.powerbi.com/t5/Gallery-Forum/Space-and-Space-Exploration-Contest/td-p/377294 Here’s a custom visual showing Twitter avatars from various Power BI team…
Microsoft recently updated the R version for Power BI Service and installed numerous additional R packages. For comparison, I posted the then-current list of packages back in July 2017. If you use R in Power BI Service, definitely see what’s available in the screenshots at the end of this post. Hopefully the Power BI documentation…
Anyone who remembers the original Power BI Custom Visual Gallery may recall seeing a visual called the Hexbin Scatterplot. It was the first visual that I created after Microsoft enabled custom visual development. When Microsoft deprecated the original dev tools and released the current API, all of the original visuals had to be rewritten in order…
If you followed my blog throughout 2016 and 2017, you may have noticed a passionate focus on mapping in Power BI. What originally started as frustration with Power BI’s nascent geospatial capabilities became a small series of celebrations as new enhancements arrived. As 2017 turned to 2018, I consciously shifted focus away from maps to…
A few days ago, John Nelson (b/t) posted an article on the ArcGIS Blog entitled Steal This Firefly Style Please. In the post, he shares his Firefly style for ArcGIS. Inspired by that post, I attempted to recreate this glow effect in Power BI. While the required gradient setting is not currently available using ArcGIS Maps…
