As much as we try to convince our colleagues to do more of their work in Power BI and less and less in Excel and PowerPoint, we all know they're going to smile and nod at us then go back to their desks and click "Export data" on our carefully developed Power BI visuals, open… Continue reading Automatically Updating Word or PowerPoint with Power BI Data
The general idea When using slicers in Power BI reports, multiple selections filter data with OR logic. For example, if you have a slicer with products and your visuals are displaying total number of invoices, then when "bicycles" and "helmets" are selected in the products slicer your visual will show the number of invoices that… Continue reading DAX measures treating slicer selections with *and* instead of *or* behavior
One of the unsung heroes to me in Power BI desktop (or Power Query in Excel) is how wonderfully simple it is to combine csv or Excel files from a folder. Maybe it's not totally unsung, but I think it's an everyday problem that many people have to deal with. It could easily be an… Continue reading My favorite clean and simple way to combine csv files in Power BI
Stephanie and I are data people. We excel at taking loads of unstructured data and making it intelligible (see what I did there?!). Do we want to be working with unstructured data? Is Excel a data collection tool? Or better yet, is Excel a database? In theory the answer to all of these questions is… Continue reading Collect/Analyze/Automate with the Power Platform
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… Continue reading Create an Interactive Legend in your Power BI Map
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… Continue reading Adding a row rank based on a different column with Power Query
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.