Power BI Basics

Composite Models in Power BI: Blending Import and DirectQuery Data

In this tutorial, we will show how you can use composite models in Power BI to blend import and DirectQuery data.

Power BI Alerts and Subscriptions: Getting Notified Before You Open the Report

In this tutorial, we will show how to use Power BI alerts and subscriptions to get notified before you open the report. Use an alert when the ...

Power BI Dataflows: Reusable ETL for Your Excel and Power BI Reports

In this tutorial, we will show how to use Power BI Dataflows to create reusable ETL (Extract, Transform, Load) for your Excel and Power BI reports. ...

How to Rename Visual Fields Without Changing Your Power BI Source Data

In this tutorial, we will show how to rename visual fields without changing your Power BI source data. At the same time, keep the data model intact.

How to Use Conditional Formatting in Power BI for Table Cell Colors

In this tutorial, we will show how to use conditional formatting in Power BI for table cell colors.

How to Add a Custom Background Image or Logo to Your Power BI Dashboard

In this tutorial, we will show how to add a custom background image or logo to your Power BI dashboard. This single change instantly elevates your ...

How to Create a “Clear All Filters” Slicer Button in Power BI

In this tutorial, we will show how to create a "Clear All Filters" slicer button in Power BI.

How to Apply a Top 10 Filter in Power BI

In this tutorial, we will show how to apply a Top 10 filter in Power BI. The built-in Filter Pane handles it in under a minute.

Getting Started with Copilot for Power BI

In this tutorial, we will show how to get started with Copilot in Power BI, including setup, examples, and best practices.

Power BI DAX Formulas to Simplify Complex Excel Calculations

In this tutorial, we will explore 5 Power BI DAX formulas to simplify complex Excel calculations. If you are an Excel power user, learning DAX ...

How to Format Currency and Percentages in a Power BI Visual

In this tutorial, we will show how to format currency and percentages in a Power BI visual.

How to Create Your First DAX Measure

In this tutorial, we will show how to create your first DAX measure by clicking New measure. We'll keep it simple and literal, just the clicks and ...

How to Change a Visual’s Data Summary from Sum to Average

In this tutorial, we will show how to change a visual’s data summary from sum to average using the field wells. Select the visual, expand the value ...

Creating and Using R Visuals in Power BI

In this tutorial, we will show how to create and use R visuals in Power BI.  Let us walk you through everything you need to know to create, publish, ...

Perform Time Series Anomaly Detection in Power BI

In this tutorial, we will show how to perform time series anomaly detection in Power BI to enhance your line charts and gain deeper insights into ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo