All classes Power BI Syllabus · Episode 5 of 7

Class Power BI #5: Dashboard Payment Analysis

2 views

Analyzing payment methods in Power BI: measure Avg Order Value that calls another measure, KPI card for orders, sales per payment method, donut chart for order proportion, sales trend per method, and average order value.

Software: Power BI Desktop
Level: Beginner
Duration: ± 6 min
Series total: 44 min · 7 videos
Published: October 7, 2026

Episode 5 of 7 · view syllabus

Download PDF (6 PDF pages)

0 downloads

Unlock All Premium Classes ▶ Watch the video lesson0 plays

▶ Video Lesson

Watch every step above performed live, with English narration.

0 plays

Class book

Page 1 / 6

Class Power BI #5: Dashboard Payment Analysis: Cover: Class Power BI #5: Dashboard Payment Analysis

Class Power BI #5: Dashboard Payment Analysis: Before you start, step list, and Step 1: Duplicate Sales2 page into Payment Analysis

Class Power BI #5: Dashboard Payment Analysis: Step 2–3: Measure Avg Order Value

Class Power BI #5: Dashboard Payment Analysis: Step 4–5: Sales by Payment Method

Class Power BI #5: Dashboard Payment Analysis: Steps 6–7: Sales trends by payment method

Class Power BI #5: Dashboard Payment Analysis: Done: Final Result and Further Practice

Cover: Class Power BI #5: Dashboard Payment Analysis

Click a page or use ◀ ▶ to turn · swipe on mobile · to enlarge

Want to go deeper?

Join one of our courses or ask us directly on WhatsApp.

Download PDF· 0 downloads View the full 7-episode syllabus View Power BI Courses Ask on WhatsApp

Need more than a video?

Other ways we can help with Power BI Desktop.

Learn with a mentor

Scheduled Data & Analytics courses with live guidance and a certificate.

Course

Course/Training Deep Learning — From Machine Learning to Deep Learning

★ 5.0 (11)

Course

Course/Training Python — Machine Learning Data Science Using Python & R

★ 5.0 (11)

Course

Course/Training Skripsi/TA/Tesis/Disertasi Mahasiswa S1/S2/S3 Visual Studio

★ 5.0 (10)

See all in Data & Analytics →

Have it built for you

No time to learn Power BI Desktop? Our team can do the project for you.

Service

Python Training Development Service

★ 5.0 (73)

Service

Development Service: Python — Complete Python Developer Zero to Mastery (2020)

★ 5.0 (14)

Service

Development Service: Django — Build Web Apps with Python, Django, Flask, Heroku, Git

★ 5.0 (12)

See all in Data & Analytics →

Get notified about new Power BI Desktop classes

At most one email a week. Unfollow anytime with one click.

Transcript

The full narration of this video. The current sentence is highlighted while the video plays; click any sentence to jump there.

Show transcript

Introduction

This is the final result of part five, Payment Analysis Dashboard. We'll look at which payment method is most commonly used, the average value of each order, and how the trend has evolved over the years. Let's get started. Hello, this is part five of the Power BI Dashboard Wave Facts series. This time, we're analyzing payment methods, credit cards, bank transfers, PayPal, and debit cards. Duplicate the sales page 2, rename it to Payment Analysis, then change the page title.

Step 2: Create the Avg Order Value measure

We'll create a measure called off-order value, which is the average value of each order. Type divide with total sales divided by the measure total orders that we already created in part two. A measure can call another measure by writing its name inside parentheses. Format as currency without decimals. Select the KPI card, remove total quantity and average profit per unit, then drag total orders and off-order value.

Step 3: Order KPI card h

The average order value is around 119 thousand dollars.

Step 4: Sales by Payment Method

We'll change our sales by category chart to sales per payment method. Clear the axes, then drag payment method. Notice, the payment method column is in two tables. Select the one in the sales table because that is the table connected to sales data. Credit cards contribute the highest sales. The title becomes sales by payment method.

Step 5: Donut chart for the number of orders per payment method

We'll change our top distributor chart to a donut chart. Clear the legend and values, then fill the legend with payment method and values with total orders. This donut chart shows the proportion of order quantities for each payment method. The title becomes orders by payment method.

Step 6: Sales trend by payment method

On the line chart for sales, simply drag payment method to the legend. One line becomes four lines, one for each payment method. The title becomes sales trend by payment method. We change our sales growth chart to the average order value.

Step 7: Average order value per payment method

Replace the x-axis with payment method and the y-axis with off-order value. It turns out that payments with debit cards have the highest average order value. The title becomes off-order value by payment.

Done! Payment Analysis Dashboard

Done. Payment analysis dashboard is ready. Save with ctrl S. See you in part 6 about the HR dashboard. Want to have a Power BI dashboard like this? Cerdas Inovasi Digital opens a Power BI course, dashboard and report automation services, as well as selling Power BI project files from this tutorial series. Contact our WhatsApp or visit cerdasinovasidigital.com. See you in the next video. See you in the next video. See you in the next video. See you in the next video. See you in the next video. See you in the next video. See you in the next video. See you in the next video. See you in the next video. See you in the next video. See you in the next video. See you in the next video. See you in the next video. See you in the next video. See you in the next video.

Ask the class material

Type a question or keyword; we find the part of this episode that explains it and jump the video there.

My notes

Notes are saved with the current video time and are only visible to you.

Questions & answers

Stuck on a step? Ask here; the instructor and other learners can answer.

No questions yet.

Your instructor

Cerdas Inovasi Digital Team

Software developers, BIM & 3D engineers, and AI practitioners

52 video classes1,276 episodes

We build software, BIM models, games and AI automations for clients every day, and turn that hands-on work into step-by-step classes: every step is shown on screen and comes with a PDF guide you can keep.

See our clients →

Memuat

Class Power BI #5: Dashboard Payment Analysis

2 views

Software

Power BI Desktop

Level

Beginner

Duration

± 6 min

Series total

44 min · 7 videos

Published

October 7, 2026

Unlock All Premium Classes

▶ Watch the video lesson0 plays

Transcript

The full narration of this video. The current sentence is highlighted while the video plays; click any sentence to jump there.

Show transcript

Introduction

Step 2: Create the Avg Order Value measure

Step 3: Order KPI card h

The average order value is around 119 thousand dollars.

Step 4: Sales by Payment Method

Step 5: Donut chart for the number of orders per payment method

Step 6: Sales trend by payment method

Step 7: Average order value per payment method

Done! Payment Analysis Dashboard

Your instructor

Cerdas Inovasi Digital Team

Software developers, BIM & 3D engineers, and AI practitioners

52 video classes1,276 episodes

See our clients →

▶ Video Lesson

Need more than a video?

Transcript

0:03Introduction

0:59Step 2: Create the Avg Order Value measure

1:47Step 3: Order KPI card h

2:14Step 4: Sales by Payment Method

2:51Step 5: Donut chart for the number of orders per payment method

3:49Step 6: Sales trend by payment method

4:27Step 7: Average order value per payment method

5:17Done! Payment Analysis Dashboard

Ask the class material

My notes

Questions & answers

Your instructor

▶ Video Lesson

Need more than a video?

Transcript

0:03Introduction

0:59Step 2: Create the Avg Order Value measure

1:47Step 3: Order KPI card h

2:14Step 4: Sales by Payment Method

2:51Step 5: Donut chart for the number of orders per payment method

3:49Step 6: Sales trend by payment method

4:27Step 7: Average order value per payment method

5:17Done! Payment Analysis Dashboard

Ask the class material

My notes

Questions & answers

Your instructor

Introduction

Step 2: Create the Avg Order Value measure

Step 3: Order KPI card h

Step 4: Sales by Payment Method

Step 5: Donut chart for the number of orders per payment method

Step 6: Sales trend by payment method

Step 7: Average order value per payment method

Done! Payment Analysis Dashboard

Introduction

Step 2: Create the Avg Order Value measure

Step 3: Order KPI card h

Step 4: Sales by Payment Method

Step 5: Donut chart for the number of orders per payment method

Step 6: Sales trend by payment method

Step 7: Average order value per payment method

Done! Payment Analysis Dashboard