Reading Time: 3 minutes 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…
Reading Time: 2 minutes 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…
Reading Time: 1 minute 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…
Reading Time: 1 minute 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…
Reading Time: 4 minutes In Tableau, INCLUDE level of detail (LOD) expressions are used to obtain values for dimensions that are not directly used in a visualization. This final LOD post focuses on adapting Tableau INCLUDE LOD expressions to DAX in Power BI. See previous posts on FIXED and EXCLUDE as well. With FIXED, I used the counterpart ALLEXCEPT function…
Reading Time: 1 minute Click on the image below to register for BlueGranite’s free webinar on Exploring Maps in Power BI. The webinar will be March 15th from 11am to Noon Eastern time. I will walk through a variety of steps to prepare and categorize your data to get the most out of your maps, survey the many visual options…
Reading Time: 4 minutes In a recent post on Tableau level of detail (LOD) expressions, I explored a method to translate FIXED to DAX in Power BI. Continuing that theme, I’ll now attempt to show an equivalent for the EXCLUDE keyword. While EXCLUDE and INCLUDE are not as common as FIXED in my experience, I’ve started down the LOD…
Reading Time: 3 minutes Back in July 2017, I experimented with interactive R HTML custom visuals in Power BI and created a simple table visual that I called R DataTable. I had originally submitted it to AppSource in October. After a few rounds of suggested changes over about four months, it is now live! That sounds like a lot…
Reading Time: 3 minutes Every once in awhile, I encounter questions from a trainee or client who is familiar with Tableau but who is getting started with Power BI. They have the ability to do X in Tableau and want to know its equivalent in Power BI. In some cases, it’s an easy answer, and in other cases, there…
Reading Time: 3 minutes In my last post, I explored a less-than-ideal way to approach the lack of object-level security in Power BI. That workaround used DAX to mask sensitive values for certain users. Since that method is not a secure one, I’ll look at an alternative that involves reshaping the data to make use of Power BI’s existing…