BLOG
Category: Power BI
-
Create an Interactive Legend in your Power BI Map
Mapping in Power BI can be super simple. Drop a field with a location in it, add a value, and you’re off to the races. Mapping in Power BI can also be challenging, and sometimes it takes a bit of trial and error to get a map close to what you want/need. This post is not about mapping options in Power BI – see the resource links below to learn it all! (seriously, visit these links – great content from great people) In this post I will show you how I created an interactive legend in Power BI that can…
-
Adding a row rank based on a different column with Power Query
Suppose you have two columns of data, one is something to group on and the other is something you could use to rank the rows. It might look something like this (grouping on Person, ranking based on Event Date): Now let’s say that you’d like to use Power Query to add a column that ranks each row based on Event Date, but groups it by Person, like this: To do this in the past, I have referred to Imke Feldman‘s response on this forum question more times than I can count. She has a wonderful little gif that shows exactly…
-
Using a Power BI perspective with Analyze in Excel
As of August 2020, perspectives can be used by your users when they are working with personalized visuals. Another place you may want to make use of the perspectives you define, though, is in Analyze in Excel.
