Category: Quick Tips

Business Intelligence - BI, DAX, Power BI, Power BI Desktop, Quick Tips, SQL Server Management Studio - SSMS

Quick Tips: Comment/Uncomment Multiple Lines in DAX Scripts

 

Comment Uncomment Multiple DAX Lines in Power BI

There are lots of cases you may want to comment/uncomment multiple lines in DAX scripts. You can save lots of development time if you know the shortcuts.

Here you go:

  • Select multiple lines of code you want to comment
  • Press Crtl+KC to comment those lines
  • Press Ctrl+KU to uncomment commented lines

Continue reading “Quick Tips: Comment/Uncomment Multiple Lines in DAX Scripts” →

Business Intelligence - BI, Power BI, Power BI Desktop, Quick Tips

Quick Tips: Hiding Multiple Columns in Power BI Desktop

From now on I will post some quick tips to help you accelerate your Power BI Desktop development. As the first post of these series, I explain a simple way for hiding multiple columns in Power BI Desktop. To do so:

  • Navigate to Relationships veiew in Power BI Desktop
  • Maximise the table you want to hide some columns in
  • Select the first column
  • Pres Shift and use arrow keys to highlight multiple columns
  • Here is the trick: DO NOT RIGHT CLICK! Instead, press the menu button on your keyboard. If your keyboard doesn’t have contect menu button, don’t worry, you can press Shift + F10 to do the same job

Menu key on PC Keyboard

  • Then click on “Hide in report view”

Enjoy!

Select Multiple Columns in Power BI Desktop