Forum Discussion
Adjusting PowerBI Desktop layout
There is a visual clue for calculated columns: they all have an icon by the name of the field:
Nevertheless, to keep things tidier, I would suggest:
1) As has been suggested for your measures, create measure tables to group the measures by categories (if necessary)
2) For calculated columns, create folders within each table to host the calculated columns. Label the folder accordingly - if you add a "1" at the start of the folder name, the folder itself will appear at the top of the list within the table.
To create a folder within a table, go to the modeling view and select the calculated column. Under properties, enter a name for the folder in "Display Folder". The folder will be created with the calculated column within:
Once the folder is created, you can add more fields by selecting and dragging into the folder:
When you go back to the field view, you will see the folder hosting the fields you have included, which you can collapse if need be:
CNENFRNL that makes sence, but for someone being given an report to optimize, it would be very handy to see what columns need to be checked. And if its a report with 100's of columns, that become tedious. As you said, loading that in memory makes load times slow, having to pass by them individually you'll have loading times, and thus delays, to see how they are actually made.
So even tho i agree to what you're saying, praktice teaches us different. And as such would love to find a way to easily mark those columns in a visual way.
