Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
Black_magic100
Helper III
Helper III

Does Power BI have display folders to store and organize measures?

I have been using power bi for 5 months now and have always wondered why they haven't added this yet.  However, I very old videos I am seeing display folders being used.  Even when I google this, I can't find the answer.  Am I really that big of an idiot and can somebody help me enable this?

1 ACCEPTED SOLUTION

If you are talking sub-folders for organizing within a table like this:

image.png

That is on the new Model tab.

image.png

 

There has never been a way to create a "folder" for just measures that I am aware of short of the hack I mentioned, at least through the April 2019 Power BI desktop. I hope that comes in the future though. 



Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

DAX is for Analysis. Power Query is for Data Modeling


Proud to be a Super User!

MCSA: BI Reporting

View solution in original post

9 REPLIES 9
Anonymous
Not applicable

Any idea how to not lose your folders when your data is refreshed?
I just spent hours putting >50 fields into folders and adding descriptions only to lose it all when I refreshed my data. My table is connected to an SQL database and refreshes every day.

That is a bug. It should not do that. Make sure you are on a recent build (Feb or Mar 2021) and retry, or the Jan Report Server version if that is what you are using. It it continues to happen, submit a bug report.



Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

DAX is for Analysis. Power Query is for Data Modeling


Proud to be a Super User!

MCSA: BI Reporting
Anonymous
Not applicable

Hi buddy,

 

There's a way to create this "folder" you want.

First go to "edit queries" menu, create a "blank query" and rename as "Measures", go to close and aply.

Now you have your "folder" and can create your measures in it.

 

Any questions, ask 😉

I already do that, but that is essentially just creating a blank table and adding formulas/calculations to it.  I was moreso referring to literal folder icons within a table to organize field and measures.  There are videos on youtube of exactly what I am referring to so I am not sure if they removed this or what happened.

If you are talking sub-folders for organizing within a table like this:

image.png

That is on the new Model tab.

image.png

 

There has never been a way to create a "folder" for just measures that I am aware of short of the hack I mentioned, at least through the April 2019 Power BI desktop. I hope that comes in the future though. 



Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

DAX is for Analysis. Power Query is for Data Modeling


Proud to be a Super User!

MCSA: BI Reporting

OMG.... That is exactly what I meant lol.  I currently have a table called _formulas, but this is what I was looking for.  You have got to be kidding me 

Cool! Yeah, this is a relatively new thing. Jan 2019 maybe? It was in beta for months so you might have seen videos going back to mid-late 2018 with them. It is handy for larger models. 



Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

DAX is for Analysis. Power Query is for Data Modeling


Proud to be a Super User!

MCSA: BI Reporting

Now I have to go through all of my reports and organize everything......... =[ =[

edhans
Super User
Super User

In Power Query, create a blank query with one column that = 0. Save and load the table with the one value.

 

Now move your measures to that "table." 

There is no native way to have a pure measures table, but this hack is what most people seem to do. Don't relate this table to anything.



Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

DAX is for Analysis. Power Query is for Data Modeling


Proud to be a Super User!

MCSA: BI Reporting

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.