EMG

Design Meets Data: From Static Slicers to Interactive Decision Aids What if your slicers could answer questions before you even select them? With a little preview context, they can guide users toward the right decisions instantly. Slicers are some of the most commonly used elements in Power BI, yet they often receive less attention than they deserve. They are frequently added to a report, filled with data, and then left for users to navigate on their own.

What if your slicers could answer your questions before you even select them?

Slicers don’t have to be static filters. With a little preview context—counts, percentages, or trend arrows—they can guide decisions instantly.

#PowerBI #DataAnalytics #DesignMeetsData #DataVisualization #PowerPlatform

Automate Power BI Refresh with Power Automate and SharePoint Learn how to trigger Power BI dataset refreshes automatically using Power Automate when new files are added to SharePoint. We have created a Power BI report that connects to a SharePoint folder where our team uploads new files every month. The process is simple: upload the file, refresh the report to incorporate the latest data, and then view the updated report.

Stop relying on fixed schedules or last-minute refresh clicks.

With Power Automate, we can trigger an event-based refresh of our Power BI reports the moment a new file hits SharePoint.

#PowerBI #PowerAutomate #PowerPlatform #SharePoint

Power BI Partial RLS Explained: Let Users See the Bigger Picture Explore how to deliver personalized insights without losing the bigger picture. This post is part two of a series on Power BI security patterns. Check out part one for a beginner-friendly overview of row-level security in Power BI. This post will take our security design pattern one step further. While row-level security (RLS) allows us to restrict data based on user roles and identities, there are times when we don't want everything locked down.

Explore how to deliver personalized insights without losing the bigger picture.

#powerbi #DAX #BusinessIntelligence #RLS #DataModeling #DataAnalysis

Power BI Row-Level Security Explained: Protect Data by User Role Discover how to personalize your reports and show each user only the data they require in just a few clicks. When creating reports for teams across various departments or regions, it's important to recognize that not everyone needs or wants to see the same data. This is where Row-Level Security (RLS) becomes essential. We can use RLS to restrict data access for report viewers based on their identity.

Discover how to personalize your reports and show each user only the data they require in just a few clicks.

#powerbi #dataanalysis #powerbideveloper #businessintelligence #dax #datagovernance

Explore Power BI Core Visualizations: Part 4 – Table and Matrix Visuals Chart your data journey! Transform data into insights with Power BI core visualizations. Table and Matrix visuals in Power BI are essential for presenting detailed and structured data. Both visuals excel at displaying large amounts of information while highlighting trends, relationships, and hierarchies. Tables offer a simple way to present data in a straightforward tabular format and are best for displaying detailed row-level data, such as sales records, inventory lists, or customer information.

Learn how to structure, format, and enhance your reports with advanced techniques for better insights. Check out the latest post in the Power BI Core Visuals series!

#powerbi #powerbicorevisuals

Power BI Feature Spotlight: Multi-Select Text Slicer, Better Treemaps, and TMDL View The Power BI update for January 2025 introduces several exciting features that improve report interactivity, visualization, modeling, and development efficiency. This post will highlight three key updates: improvements to the text slicer, upgrades to the treemap visual, and the preview of TMDL scripting experience. The text slicer (preview) was introduced in November 2024, now allows mutli-selection, addressing a major limitation in text-based filtering.

The January 2025 Power BI update adds multi-selection to the text slicer, new treemap layout options, and a preview TMDL scripting experience.

#powerbi #dataanalysis #powerbideveloper #powerbicorevisuals

Enhancing Bar Charts in Power BI: A 2025 Workout Wednesday Challenge Make your Power BI reports more impactful—learn how to highlight key data points in a bar chart! Workout Wednesday is a weekly challenge series designed to help develop Power BI skills through hand…

The 2025 Power BI Week 5 Workout Wednesday Challenge focuses on adding a Total Average category to a bar chart and applying conditional formatting.

Here is how I approached this challenge. How would you?
#WOW2025 #PowerBI

@mmarie.bsky.social
@shan-gsd.bsky.social
@merrykerry.bsky.social

Dive into DAX: Unlock the Full Potential of FORMAT Learn how to create interactive, audience-friendly visuals with custom formatting and dynamic insights I recently participated in a data challenge and used it to explore dynamic titles and subtitles in the final report. Dynamic titles provide context, guide users to key insights, and create a more interactive experience. Dynamic titles were created by developing DAX measures that utilized various DAX functions, including FORMAT.

Dive into DAX: Unlock the Full Potential of FORMAT

Learn how to create interactive, audience-friendly visuals with custom formatting and dynamic insights.

#powerbi #dax #powerbitutorial #powerbideveloper #dataanalytics

Elevate Power Automate Error Handling with Centralized Failure Notifications Learn how to create a dynamic failure notification framework across Teams channels with a centralized SharePoint setup Handling errors in Power Automate workflows can be challenging, especially whe…

Streamline error handling in Power Automate! Learn how SharePoint and Teams enable reusable, hassle-free notifications with solution-aware flows, Teams channels/tags, and centralized contacts. Enhance your workflows today.

#PowerAutomate #MicrosoftTeams #SharePoint #PowerPlatform

Power BI Feature Spotlight: Data Filtering and Modeling Stay ahead of the latest features with a focused look at Power BI’s latest features, their benefits, and use cases. Dive into walkthroughs and tips to enhance your reports. The Power BI November 20…

Power BI Spotlight: November 2024 Update
Introduces the Text Slicer for filtering with typed input and a quick query option to define measures in DAX view. These tools simplify data exploration and reporting.

#powerbi #powerbitutorial #dataanalytics #powerbideveloper #powerbicorevisuals

Dive into DAX: Getting Started with DAX Query View A Beginner’s Guide to Exploring Data Models with DAX Queries Getting Started with DAX Query View DAX Query View in Power BI Desktop lets us interact directly with our data model using DAX que…

Dive into DAX and get started with DAX Query View.

With DAX Query View, we can explore our data in a dedicated workspace without impacting our report or data model. Quick Queries, CodeLens, and Intellisense make exploring and analyzing our Power BI data easier than ever.

#powerbi #dax

Dive into DAX: Elevated Insights with Information Functions Navigate Data Complexities with Ease and Accuracy In data analytics effectively navigating, understanding, and interpreting our data can be the difference between data-driven insights and being los…

Dive into DAX: Elevated Insights with Information Functions - a guide to navigating data complexities with ease and accuracy. Perfect your Power BI skills and unlock deeper insights.

#powerbi #dataanalysis #DAX #daxfunctions #businessintelligence

Design Meets Data: A Guide to Building Engaging Power BI Report Navigation Streamlined report navigation with built-in tools to achieve functional, maintainable, and engaging navigation in Power BI reports. Before we begin developing the navigational element of our report…

Design Meets Data: Exploring the intersection of design and data visualization.

Enhancing report navigation using built-in tools for functional, maintainable, and engaging navigation in Power BI reports.

#powerbi #dataanalytics #powerbideveloper #dashboarddesign #businessintelligence

Design Meets Data: Crafting Interactive Navigations in Power BI User-Centric Design: Next level reporting with interactive navigation for an enhanced user experience. An essential aspect of any multi-page report is an effective and intuitive way to navigate bet…

Explore enhancing user experience in Power BI with interactive navigation using built-in tools. This post crafts a compact navigational pane that is expandable and provides customizable templates for implementation.

#powerbi #dataanalytics #powerbideveloper #dashboarddesign #businessintelligence

Design Meets Data: A Guide to Building Interactive Power BI Report Navigation The post discusses the process of enhancing Power BI report navigation by leveraging Figma’s design capabilities. It emphasizes the importance of intuitive navigation and provides a detailed …

From Sketch to Screen: Bringing your Power BI report navigation to life.

ethanguyant.com/2024/02/15/d...

#powerbi #figma #microsoft #dataanalytics #dataanalysis #powerbideveloper #uxdesign #designtips #dashboarddesign

Design Meets Data: The Art of Crafting Captivating Power BI Themes Dive into the details of blending design and data with custom Power BI themes. At the intersection of design and data, crafting Power BI themes emerges as a crucial skill for effective and impactfu…

Design Meets Data: The Art of Crafting Captivating Power BI Themes - dive into the details of blending design and data with custom Power BI themes.

#powerbi #dataanalytics #powerbideveloper #designtips #dashboarddesign #businessintelligence

ethanguyant.com/2024/03/22/d...

DAX Table Manipulation Functions: Transforming Your Data Analysis Discover how to Reshape, Manipulate, and Transform your data into dynamic insights. Exploring DAX: Table Manipulation Functions Dive into the world of DAX and discover its critical role in transfor…

Dive into DAX Table Manipulation Function: Discover how to reshape, manipulate, and transform data into dynamic insights.

#powerbi #dataanalysis #daxfunctions #dax

ethanguyant.com/2024/02/04/d...

Power BI Feature Spotlight: Data Filtering and Modeling Stay ahead of the latest features with a focused look at Power BI’s latest features, their benefits, and use cases. Dive into walkthroughs and tips to enhance your reports. The Power BI November 20…

The November 2024 #PowerBI update introduces the Text Slicer for precise filtering by entering text and the Define a new measure quick query option in DAX query view, streamlining measure creation for faster analysis.

Explore how these updates enhance Power BI reporting!