Power BI Masterclass - DAX How to Get Different Formatting in the Same Column in Power BI

Power BI Masterclass - DAX How to Get Different Formatting in the Same Column in Power BI

Assessment

Interactive Video

Information Technology (IT), Architecture

University

Hard

Created by

Quizizz Content

FREE Resource

The video tutorial demonstrates how to visualize different kinds of formatting in Power BI using a matrix. It covers setting up categories and ship modes, creating measures to calculate total sales, and using DAX to calculate percentage sales by category and ship mode. The tutorial also explains how to apply formatting to display currency and percentage in the same column, highlighting the use of the switch function and the implications of text conversion.

Read more

10 questions

Show all answers

1.

OPEN ENDED QUESTION

3 mins • 1 pt

What is the first step to visualize a matrix in Power BI?

Evaluate responses using AI:

OFF

2.

OPEN ENDED QUESTION

3 mins • 1 pt

How can you extend the hierarchy in a matrix visual?

Evaluate responses using AI:

OFF

3.

OPEN ENDED QUESTION

3 mins • 1 pt

What measures can be used in the measures table for visualization?

Evaluate responses using AI:

OFF

4.

OPEN ENDED QUESTION

3 mins • 1 pt

Describe the process of creating a new measure in Power BI.

Evaluate responses using AI:

OFF

5.

OPEN ENDED QUESTION

3 mins • 1 pt

What is the purpose of the CALCULATE function in DAX?

Evaluate responses using AI:

OFF

6.

OPEN ENDED QUESTION

3 mins • 1 pt

Explain how to use the SUMMARIZE function in DAX.

Evaluate responses using AI:

OFF

7.

OPEN ENDED QUESTION

3 mins • 1 pt

What is the significance of the 'is filtered' function in DAX?

Evaluate responses using AI:

OFF

Create a free account and access millions of resources

Create resources
Host any resource
Get auto-graded reports
or continue with
Microsoft
Apple
Others
By signing up, you agree to our Terms of Service & Privacy Policy
Already have an account?