Power Query Editor: Data transformation and cleaning tool inside Power BI Desktop.
Data Modeling: Create relationships, calculated columns, and measures using DAX (Data Analysis Expressions).
Visualizations: Drag and drop various charts, maps, and KPIs to build interactive reports.
Dashboards: Combine multiple reports and visuals into a single interactive dashboard.
Power BI Service: Cloud platform to publish, share, and collaborate on reports and dashboards.
Ctrl + N - Create new Power BI report
Ctrl + S - Save current report
Ctrl + Z - Undo last action
Ctrl + Y - Redo last undone action
Ctrl + Shift + C - Copy visual
Ctrl + Shift + V - Paste visual
Ctrl + Click (on a visual) - Select multiple visuals
Alt + Shift + Right Arrow - Drill down in a hierarchy
Alt + Shift + Left Arrow - Drill up in a hierarchy
// Calculate total sales
Total Sales = SUM(Sales[SalesAmount])// Filter rows where SalesAmount > 1000
= Table.SelectRows(Source, each [SalesAmount] > 1000)