Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.

Nolock
Resident Rockstar
‎07-13-2019 11:41 PM

Display Folder Property in Power BI Desktop

I used to work on a full-text search engine. Back then, we often paraphrased a famous Albert Einstein’s quote “Organized people are just too lazy to search”.


In Power BI Desktop you can search for tables and columns within your model. Because the searched space is tiny, you can use all the fancy stuff like infix search, for example. It works amazingly!

1.PNG

 

But I am an organized person and I don’t like searching. I prefer order to disorder! But that’s not easy if you have a table with many columns. Therefore, I am very happy that I can group columns of a table in the Power BI Desktop like on the following screenshot.

2.PNG

 

How to do that? Open Power BI Desktop, go to the Model view, click on a field among Fields and set Display folder. If you want to create a hierarchy of folders, delimiter parts of your path with a backslash like “battery\properties”.

3.PNG

 

When searching, you also see your hierarchical structure.

4.PNG

Comments