Cheat Sheets

Power BI Cheat Sheet

Quick reference for Power BI — from loading data and Power Query transformations to DAX measures, chart types, and data profiling.

SQLPythonPower BIDAXM CodeMicrosoft FabricSnowflakeDatabricksGitVS CodeVimHomebrewHTMLCSS3JSONJavaJavaScriptAI PromptsMarkdownData Warehouse

Connect. Transform. Visualize.

Components & Views
Power BI DesktopPower BI ServicePower BI MobileReport ViewData ViewModel View
Connecting Data
Get DataLoad datasetTransform DataData view inspectionRefresh dataCreate relationship
Power Query Editor
Open (on load)Open (already loaded)Applied StepsRemove RowsAdd ColumnReplace ValuesChange Data TypePromote HeadersSplit ColumnPivot / UnpivotGroup ByMerge QueriesAppend Queries
Join Types
Left OuterRight OuterFull OuterInnerLeft AntiRight Anti
Data Visualizations
Bar ChartColumn ChartLine ChartArea ChartScatter ChartCombo ChartTreemapPie ChartDonut ChartMapCardTableMatrixSlicer
Creating Visuals
Add a visualFields: Values vs AxisChange aggregationFormat visualDrill downCross-filter
DAX in Power BI
New MeasureNew ColumnSUM / AVERAGECOUNT / DISTINCTCOUNTIF (conditional measure)CALCULATE (context modifier)DIVIDE (safe division)LEFT / LOWER / UPPERCALENDAR (date table)WEEKDAYTOTALYTD (time intelligence)
Data Profiling
Enable Data ProfilingColumn QualityColumn DistributionColumn ProfileProfile based on entire datasetError inspection
Publishing & Sharing
Publish to ServiceShare a reportSchedule refreshExport to PDF / PowerPointEmbed in Teams / SharePointRow-Level Security (RLS)