Functions in Power Query's "Query Dependencies" view
In Power Query, right-click on a query and choose Create Function. This makes a function whose definition is based on that query, and when the query is edited, the function is automatically updated. I like this. When I use the Query Dependencies view, it is hard to see which functions depend o...
Breadcrumbs (Back button) browsing queries in Power Query
Sometimes I need to track down the origin of some data that is coming out of Power Query. This is a process of taking steps forward and backward in a tree of queries. If I'm not writing down the name of the query each time I switch to a different query, it can be easy to lose my place in the tr...
Pinned axis values on visuals with continuous values (vertical or horizontal)
Use case: I am plotting percentages on a line chart. These values shouldn't be below zero, but I want to see them if they do. They shouldn't be above 100% but I definitely want to see them if they do. Because I need the extents of the line chart to float, I can't hard-code min and max valu...