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”
Category: Excel
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”
Dynamically Subsetting Table Visuals In Power BI
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”
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”
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”
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”
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”
New Modern Visual Tooltips For Power BI
For todayās video, Iād like to talk about the new Modern Visual Tooltips released just yesterday. The May 2021 Power BI updates is not a hugely exciting update but the Modern Visual Tooltips in particular is a feature that I Continue reading “New Modern Visual Tooltips For Power BI”
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”