Power BI Skills

What are the Prerequisites to Learn Power BI?

Tuesday, February 1st, 2022

The Power BI training assumes some familiarity with relational databases....

Choose between continuous and categorical axes

Tuesday, February 1st, 2022

The PL-300 exam skills guide has a topic, "choose between...

Case Study 2

Friday, October 1st, 2021

Background Flexi Travel is a bus company that provides shuttle...

Case Study 1

Friday, October 1st, 2021

Background Sunrise Group Inc. is a retail giant that has...

DAX Practice: PREVIOUSYEAR and SAMEPERIODLASTYEAR

Monday, June 21st, 2021

We want to set the Units sold to be 10%...

Fill Down Practice

Friday, June 18th, 2021

Dowload data for Fill Down Example Opening the data in...

DAX Practice: RankX

Friday, June 18th, 2021

We have two tables, Sales and Product: Loading the data...

Passing DA-100

Friday, June 4th, 2021

My experience will help you pass the Power BI Exam....

Getting Sum of Last Available Date in Month

Thursday, May 20th, 2021

Suppose you want to know how many items were purchased...

Creating a histogram

Monday, May 17th, 2021

Right-click on Quantity and select New Group Group types can...

Column Quality, Column Distribution & Column Profile

Monday, May 17th, 2021

Here' s a table showing what does what. To summarize,...

DAX practice: Counting the number of items selected on a slicer

Friday, May 14th, 2021

Load the purchase data into power bi. The data model...

Changing Interactions

Wednesday, May 12th, 2021

Select the visual on the left to change how clicking...

Conditional Formatting

Wednesday, May 12th, 2021

Load the Salary Sample data in PowerBI Desktop and create...

Drill Through

Wednesday, May 12th, 2021

Open the Salary Sample and create a Salary By Title...

Turn on Dashboard Tile Flow

Wednesday, May 12th, 2021

Dashboard Tile Flow will automatically reposition tiles to keep your...

Pin a live page

Wednesday, May 12th, 2021

On the Power BI Service, select a report. Then, on...

Filter Customizations

Wednesday, May 12th, 2021

Disabling Search Select File, then Options and Settings Uncheck "Enable...

Use an image for navigation

Wednesday, May 12th, 2021

Starting with this workbook and on the Insert tab select...

Use bookmark and buttons for navigation

Wednesday, May 12th, 2021

Connect to the shipping cost data Create a couple pages:...

Adding Tooltip to Visual

Monday, May 10th, 2021

I created mock data with mockaroo.com which you can download...

Adding an alert to a dashboard

Monday, May 10th, 2021

The documentation explains, "Alerts can only be set on tiles...

Changing Theme in Report and in Dashboard

Monday, May 10th, 2021

In PowerBI Desktop, select the View tab and switch from...

Creating a Mobile Layout with a Responsive Slicer for a Report

Monday, May 10th, 2021

In the Mobile Layout report editor you can reposition or...

Q&A On under Page Information

Monday, May 10th, 2021

On a report, with none of the visuals selected, click...

Turning Q&A on and off for a dashboard

Monday, May 10th, 2021

To add the Q&A option to a dashboard Setting menu...

Create workbook visual showing MOM % change

Monday, May 10th, 2021

Open a new workbook and connect to the shipping cost...

Create a Power BI visual showing current month next to same month from prior year

Friday, May 7th, 2021

I created sample data with a date column and a...

Registering for the DA-100 Exam

Thursday, April 22nd, 2021

Here are the steps to register for the DA-100 Exam!...