Today, we do a deep dive into a question about how to dynamically subset table visuals in Power BI based on slicer values. We’ll tap on a bunch of interesting elements including disconnected tables, slicer harvesting, slicer visualization tricks, virtual Continue reading “Dynamically Subsetting Table Visuals In Power BI”
Author: Bb
The Ultimate Dynamic Menu In Power BI
In this video, I’ll demonstrate how you can create a dynamic filters menu to increase the user experience in your Power BI reports. There are a lot of options in Power BI, you can have filters shown on the page, Continue reading “The Ultimate Dynamic Menu In Power BI”
Reports & Visualizations Pt. 2 – Power BI Best Practices Vol. 4
In this video, I’ll continue discussing my best practices for reports and visualizations. This is Volume 4 of the mini series we’ve made about Power BI Best Practices. This particular volume is split into 2 parts. These are some of Continue reading “Reports & Visualizations Pt. 2 – Power BI Best Practices Vol. 4”
How Collaboration Can Produce Amazing Reporting Applications In Power BI
In this video, I want to showcase how collaboration can produce one of the most incredible reports I’ve seen in Power BI. This particular work was created by a group of Enterprise DNA experts better known as “JMAP”, as their Continue reading “How Collaboration Can Produce Amazing Reporting Applications In Power BI”
Goal Seek Replaces Algebra – 2283
Check out Rob Collie’s Raw Data podcast: https://powerpivotpro.com/rawdatapodcast/
Today, I ran across an unanswered question in a Math board. No one really needs to know this answer. It is a high school math teacher trying to trick people Continue reading “Goal Seek Replaces Algebra – 2283”
Lambda Functions Debut In Excel – 2381
New! Post your LAMBDA functions to https://www.mrexcel.com/board/forums/excel-lambda-functions.40/
Ground-breaking news in Excel. The partner to the LET function was just released. Check out the new LAMBDA function in Excel. This makes the Excel formula language Turing Complete. Store formula Continue reading “Lambda Functions Debut In Excel – 2381”
Look Ahead Selecting Names From List in Excel – 2380
Excel has supported the List option in Data Validation for a decade. But let’s face it: it is not easy to select from the list. You can’t start typing and have the list shorten to just the matches, also known Continue reading “Look Ahead Selecting Names From List in Excel – 2380”
Unhide Multiple Worksheets In Excel – 2379
A simple improvement to Excel appeared in November 2020: You can now unhide multiple worksheets at once. This feature is rolling out to Office 365 subscribers.
Yes!!! Define Your Own Linked Data Types in Excel! Episode 2378
It is like the Christmas where you got almost every thing you asked for. The Excel team has given us almost everything I asked for with the new data types. You can now create your own data types in Excel, Continue reading “Yes!!! Define Your Own Linked Data Types in Excel! Episode 2378”
Free Power BI Resource Collection Including Dataset Builder Tool
For today’s video, I wanted to spend some time highlighting a fantastic new free resource collection available to both Enterprise DNA members and non-members. I’ll also be particularly demonstrating a tool called Data Randomizer, which can be used to build Continue reading “Free Power BI Resource Collection Including Dataset Builder Tool”
Top 10 Power BI Best Practices
Today, I’m going to share my personal Top 10 Best Practices for Power BI. Over the past months, I’ve released a series of videos showcasing a number of best practices addressing the 4 pillars in Power BI report development. I Continue reading “Top 10 Power BI Best Practices”
Achieving Project Balance In Power BI – Problem Of The Week #11 Solution
Greg Philps leads Problem of the Week #11. A not-uncommon problem that almost every Power BI user experiences is maintaining project balance. A project expands in scope over time, and when one side of the “Project Management Triangle” changes, at Continue reading “Achieving Project Balance In Power BI – Problem Of The Week #11 Solution”