Power BI Guides

    This page lists every Power BI tutorial available on Statology.

    Power BI: How to Count Number of Occurrences
    Power BI: How to Write an IF Statement
    Power BI: How to Write an IF Statement with Multiple Conditions
    Power BI: A Simple Formula for “If Contains”
    Power BI: How to Replace Blanks with 0
    Power BI: How to Replace Blanks with Text
    Power BI: How to Convert Date to Text
    Power BI: How to Convert Date to Month and Year
    Power BI: How to Convert Date to Quarter and Year
    Power BI: How to Convert Date to YYYYMMDD Format
    Power BI: How to Get Day of Week from Date
    Power BI: How to Create a Table Using DAX
    Power BI: How to Create Table from Another Table Using DAX
    Power BI: How to Add Index Column to Table
    Power BI: How to Extract Year from Date
    Power BI: How to Extract Month from Date
    Power BI: How to Extract Date from Datetime
    Power BI: How to Extract Hour from Datetime
    Power BI: How to Extract Substring
    Power BI: How to Write a Case Statement
    Power BI: How to Use VLOOKUP
    Power BI: How to Create a Stacked Column Chart
    Power BI: Display Percentage in Stacked Column Chart
    Power BI: How to Calculate Percent of Total
    Power BI: How to Calculate Percent of Total by Category
    Power BI: How to Calculate Percent Change
    Power BI: How to Rank Values by Group
    Power BI: How to Plot Multiple Lines on Line Chart
    Power BI: How to Add Trend Line to Line Chart
    Power BI: How to Create a Line Chart by Month
    Power BI: How to Create a Line Chart by Month and Year
    Power BI: How to Calculate a Cumulative Sum
    Power BI: How to Calculate Cumulative Sum by Category
    Power BI: How to Create a Cumulative Line Chart
    Power BI: How to Remove Duplicates
    Power BI: How to Remove Date Hierarchy
    Power BI: How to Remove Column Headers in Table
    Power BI: How to Remove Blank Rows
    Power BI: How to Remove “Total” Row from Table
    Power BI: How to Remove Blank Option from Slicer
    Power BI: How to Remove Characters from String
    Power BI: How to Remove (Blank) from Card Visualization
    Power BI: How to Calculate Standard Deviation
    Power BI: How to Calculate Median
    Power BI: How to Calculate Average
    Power BI: How to Calculate Average By Month
    Power BI: How to Calculate Average and Ignore Zeros
    Power BI: How to Use AVERAGE IF
    Power BI: How to Use SUM IF
    Power BI: How to Calculate Sum
    Power BI: How to Calculate Sum with Filter
    Power BI: The Difference Between SUM vs. SUMX
    Power BI: How to Sum Multiple Columns
    Power BI: How to Calculate Max
    Power BI: How to Find Max of Multiple Columns
    Power BI: How to Find Max Date
    Power BI: How to Ignore Filter for a Measure
    Power BI: How to Compare Two Columns
    Power BI: How to Concatenate Two Columns
    Power BI: How to Concatenate More Than 2 Columns
    Power BI: How to Use First Row as Header
    Power BI: How to Calculate a Correlation Coefficient
    Power BI: How to Normalize Data Between 0 and 1
    Power BI: How to Create a Pivot Table
    Power BI: How to Apply Conditional Formatting to Text Column
    Power BI: How to Apply Conditional Formatting to Bar Chart
    Power BI: How to Apply Conditional Formatting to a Card
    Power BI: How to Calculate Z-Scores
    Power BI: How to Count Distinct Values in Column
    Power BI: How to Count Distinct Values with Filter
    Power BI: How to Get Distinct Values from Multiple Columns
    Power BI: How to Create Measure with Multiple Filter Conditions
    Power BI: How to Create Measure and Filter on Multiple Values
    Power BI: How to Filter Between Two Dates
    Power BI: How to Calculate Number of Days in Month
    Power BI: How to Get First Day of Week
    Power BI: How to Perform Data Binning
    Power BI: How to Add Row to Table
    Power BI: How to Add Column from Another Table
    Power BI: How to Add Search Bar to Slicer
    Power BI: How to Add Week to Date Hierarchy
    Power BI: How to Add Average Line to Chart
    Power BI: How to Add Days to Date
    Power BI: How to Add Months to Date
    Power BI: How to Show Both Value and Percentage in Bar Chart
    Power BI: How to Change Column Width in Table
    Power BI: How to Sort a Stacked Column Chart
    Power BI: How to Only Show Top 10 Values in Chart
    Power BI: How to Change Legend Order
    Power BI: How to Perform Simple Linear Regression
    Power BI: How to Round to 2 Decimal Places
    Power BI: How to Round Time to the Nearest Hour
    Power BI: How to Round Time to Nearest Quarter Hour
    Power BI: How to Calculate Difference Between Two Columns in Table
    Power BI: How to Calculate Days Between Two Dates
    Power BI: How to Calculate Days Between Date and Today
    Power BI: How to Calculate Working Days Between Two Dates
    Power BI: How to Fill Blanks with Previous Value
    Power BI: How to Use SUMMARIZE with FILTER
    Power BI: How to Select Rows Based on Condition
    Power BI: How to Use “Not Equal” Operator
    Power BI: How to Use “NOT IN” Operator
    Power BI: How to Perform a Left Join
    Power BI: How to Perform an Inner Join
    Power BI: How to Perform an Anti Join
    Power BI: How to Change Order of Columns
    Power BI: How to Calculate Quartiles
    Power BI: How to Perform Fuzzy Matching
    Power BI: How to Calculate YTD (Year to Date) Values
    Power BI: How to Transpose a Table