Have you ever wanted to know where a column or measure is actually being used in Power BI report visuals? Find out easily with the Power BI Field Finder!
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
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.