My ideas, tips and comments on data, analytics and visualization
A friend asked me about a way to allow users to display line level information - what you normally do with a drillthrough page - however, not for a single line, but for all currently selected items in the table object, i.e. if you have a simple table, like the one below: How can we … Continue reading Drill-Through to Subtotal’s Details in Power BI
In Power Query, we have the option to use Fuzzy Match when merging tables. A little known feature are the Translation Tables which help in that process. Merging tables is relatively straightforward in Power Query - choose the left table, choose the right table, mark the columns for the merge to be made onto, choose … Continue reading What are translation tables in Power Query’s Fuzzy Match and why would we need them?
If you don't have the time to read the full article, here's a 1 min GIF below. But if you do, I'd b happy if you read further: The detailed explanation: I was working on a demo to show the benefits of using a disconnected table when I decided to try and make something interesting … Continue reading Switching items with a radio buttons in Power BI
Vitali on Data 