467
订阅者
无数据24 小时
+77 天
+3430 天
帖子存档
Top 20 Power BI DAX Shortcuts!
1️⃣ Ctrl + N – New Measure Quickly create a new DAX measure for your report.
2️⃣ Ctrl + Shift + N – New Table Add a new table to your data model with ease.
3️⃣ Ctrl + Shift + M – New Calculated Column Create a calculated column without leaving your current view.
4️⃣ Ctrl + Shift + F – Format Painter Copy formatting from one visual and apply it to another.
5️⃣ Ctrl + Shift + D – Duplicate Measure Create a duplicate of your current measure to modify or use as a base.
6️⃣ Ctrl + Shift + R – Refresh Data Refresh all your data sources with a single click.
7️⃣ Ctrl + Shift + C – Calculate Column Calculate the column values quickly.
8️⃣ Ctrl + Shift + B – Show/Hide Fields Pane Toggle the visibility of the Fields pane to focus on your report or data model.
9️⃣ Ctrl + Shift + P – Preview Data Quickly preview the data in your selected table.
🔟 Ctrl + Z – Undo Revert the last change you made—handy for quick fixes!
1️⃣1️⃣ Ctrl + Y – Redo Redo the last action that was undone.
1️⃣2️⃣ Ctrl + F – Find/Replace Search for specific DAX formulas or text within your model.
1️⃣3️⃣ F2 – Edit Formula Quickly edit the selected DAX formula in the formula bar.
1️⃣4️⃣ Ctrl + Shift + L – Show/Hide Filters Pane Toggle the visibility of the Filters pane for better workspace management.
1️⃣5️⃣ Ctrl + Shift + T – Create Table Visual Instantly add a table visual to your report for data exploration.
1️⃣6️⃣ Ctrl + Shift + G – Group Visuals Group multiple visuals together for easier management.
1️⃣7️⃣ Ctrl + Shift + H – Hide/Unhide Visuals Toggle the visibility of visuals to focus on specific elements.
1️⃣8️⃣ Ctrl + Shift + Q – Quick Measures Generate quick measures without manually writing DAX code.
1️⃣9️⃣ Ctrl + Shift + S – Save Report Save your current report with a single shortcut.
2️⃣0️⃣ Ctrl + Shift + V – Paste Visual Paste a copied visual into your report seamlessly.
Credits: Pankaj Namekar
Semantic Modeling WITHOUT third-party tools https://www.linkedin.com/pulse/semantic-modeling-without-third-party-tools-daniel-otykier-okr8f
Configure Incremental Refresh using Tabular Editor
https://docs.tabulareditor.com/common/CSharpScripts/Advanced/script-implement-incremental-refresh.html
Downloading a Power BI dataset to a .pbix using the XMLA endpoint
https://docs.tabulareditor.com/te3/powerbi-xmla-pbix-workaround.html?utm_source=linkedin&utm_medium=organic&utm_campaign=blog&utm_id=blog&utm_content=blog-powerbi-xmla-pbix-workaround.html
