Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Solved! Go to Solution.
If you are talking sub-folders for organizing within a table like this:
That is on the new Model tab.
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.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingAny 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.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingHi 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:
That is on the new Model tab.
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.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingOMG.... 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.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingNow I have to go through all of my reports and organize everything......... =[ =[
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.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingCovering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |