Revisiting Common Calculation Group Patterns in Power BI! - 12/26/2023

Learn about a technique to to rename columns containing either CamelCase or underscore (_) title formatting in Power Query. This technique was originally posted by Jani Zajc (links below) who collaborated with Gil Raviv to create this technique, and which was inspired by a post by Chris Webb (so many people!). Tune in to learn more!

IMPROVED - IBCS Styled Bullet Charts (SVG) in Power BI! - 12/12/2023

Join Daniel Marsh-Patrick and myself as we explore a NEW and IMPROVED SVG image template to add an IBCS (International Business Communication Standards) inspired bullet chart to your native matrix or table visuals in Power BI Desktop!

Automatically Rename CamelCase Columns in Power Query! - 11/14/2023

Learn about a technique to to rename columns containing either CamelCase or underscore (_) title formatting in Power Query. This technique was originally posted by Jani Zajc (links below) who collaborated with Gil Raviv to create this technique, and which was inspired by a post by Chris Webb (so many people!). Tune in to learn more!

Three Techniques for Curating the User Experience in Power BI! - 11/07/2023

Learn about three primary techniques for simplifying and curating the user experience for reports in Power BI. There's a mixture of art and science that goes into smart report design, especially designs that minimize pop-ups, distractions, and user interactions. Tune in to learn more!

Exploring the NEW Semantic Model View + Native Calculation Groups! - 10/24/2023

Learn about the new semantic model view in Power BI Desktop. Plus, learn see how we can now add Calculation Groups natively in Power BI Desktop, without requiring External Tools. Tune in to learn more!

Folder Organization for...Tables?!? Using Tabular Editor 3 - 10/16/2023

Learn an improved way to merge or append queries (as new) by adding an additional source applied step. Ken Puls will walk you through this, and why it'll benefit your query logic moving forward. Tune in to learn more!

Improving Merging & Appending Power Query (Queries) with Ken Puls - 9/19/2023

Learn an improved way to merge or append queries (as new) by adding an additional source applied step. Ken Puls will walk you through this, and why it'll benefit your query logic moving forward. Tune in to learn more!

Extracting SQL Database/Table Names From Your Power BI Dataset! - 9/12/2023

Learn how to query the XMLA end-point in a Premium (Per User or Capacity) workspace to extract all the Power Query M Code, and parse out your SQL Database names, table, names, and parameters from your queries. Tune in to learn more.

Simplifying [DAX] with Staging Tables & Relationships - 8/22/2023

Learn how to leverage model tables/columns, and relationships to simplify your DAX code for your Power BI datasets (models), leading to simpler measures, and potentially more efficient (faster) calculations and visual queries. Tune in to learn more!

One-Click Time Intelligence Measures with Tabular Editor Scripts! - 8/8/2023

Learn how to leverage C# scripts in Tabular Editor 2 or 3 to create instant Time Intelligence DAX measures off any existing calculations already in your model. This is a huge time savor for applying common date pattern calculations instantly with just a couple clicks in Tabular Editor.

Custom Data Labels, Curved Lines, and Leader Line Labels (OH MY!) - 8/1/2023

Learn how to enhance your visualizations with custom DAX data labels plus leader lines. Additionally, learn how to upgrade your native line chart visuals using the smooth line option. Tune in to see them in action!

Configuring Fields with Perspectives for Shared Datasets in Power BI - 7/16/2023

Learn how create and access perspectives for Power BI Datasets. Perspectives allow you to configure the visibility of all dataset fields per perspective to fit multiple audience needs. This is really useful for more complex models where multiple audiences would only need to see a subset of the fields contained in the master dataset. Unlock these secrets using Tabular Editor, and composite modeling. Tune in to learn more!

New (AND IMPROVED) Native Card Visual for Power BI !?! - 6/19/2023

Let's explore the NEW and IMPROVED native card visual for Power BI! Not only does it allow multiple values, but it has a lot of additional formatting options, support for SVG charts, and more. Tune in to find out!

[DAX] Dynamic Format Strings WITHOUT Calculation Groups ?!? - 5/30/2023

Learn how to add Dynamic Format Strings for individual [DAX] measures in Power BI! This technique doesn’t require calculation groups or Tabular Editor either, and can be done entirely inside of Power BI desktop.

Side note, if you aren’t using Tabular Editor as a model developer you should be. It’s a fantastic tool for any intermediate to advanced modeling scenarios, and the only way to add calculation groups (today).

Hiding Measures from [DAX] Intellisense! - 4/4/2023

When creating datasets with build permissions (shared datasets), many of us know to hide fields from the data pane. But did you know you can also "hide" measures from the intellisense list in DAX? In this video learn how to use tabular to configure a table property to hide any measures inside of that table, from any DAX intellisense when writing measures. Further increasing usability when creating shared datasets in the Power BI service!

PLEASE NOTE this is not (officially supported) by Microsoft. But is a relatively safe setting to modify. Just be aware Microsoft doesn't provide support for this. More info below at the tabular editor link

IBCS Styled Bullet Chart for Native Tables in Power BI! - 3/21/2023

Learn how to utilize an SVG image template to add an IBCS (International Business Communication Standards) inspired bullet chart to your native matrix or table visuals in Power BI Desktop.

Customizable Height & Width for SVG Images - 3/14/2023

Learn about a recent update to the native table and matrix visuals in Power BI that let you customize the pixel height and width of the image view box. This addition has drastically increased the usability of SVG images to create many different types of vertical charts, KPIs, and other visualizations right inside of table visuals. Tune in to learn more!

New Way to Apply Conditional Formatting by Category - 2/21/2023

Learn about an update included with the February 2023 release of Power BI Desktop that makes applying conditional formatting by category (text) very easy to do. Before this release a solution like this would require a dedicated DAX measure to convert categories (text) to numbers before using it in the conditional formatting menu.

Intro to Categorical Slicers & Options in Power BI - 2/6/2023

Learn about all the configuration options, default publishing considerations, and design choices when adding a categorical slicer (filter) to a Power BI report! Tune in to learn more!

Improved & Free Multi-Value Card! - 1/24/2023

Learn how to utilize the custom visual from SQLBI (Cards with States) as a robust KPI and multi-category (trellis) card visual in Power BI. You'll see multiple ways that this card provides an upgraded visual experience vs the native single value or KPI cards built into Power BI. Tune in to learn more!

Improving the Data Bar for Tables in Power BI! - 1/17/2023

Learn how to split the data bar conditional format (visual) and value (label) for table and matrix visuals in Power BI! Plus see some considerations for addressing hierarchies and sub-totals for matrixes. Tune in to learn more!

Introduction to Using URLs for Reports in Power BI! - 1/3/2023

Learn how to add either dynamic or fixed URL links in Power BI. This video will review tables, matrixes, and other objects where you can add URL hyperlinks. Tune in to learn more!