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
Category: English Articles
What are translation tables in Power Query’s Fuzzy Match and why would we need them?
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?
Switching items with a radio buttons in Power BI
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