NOTE!! -- After posting I learned that Folder Hierarchy CAN also be accomplished natively in PBI without Tabular Editor. You can perform this by changing the Display Folder to value Folder\Folder\Folder, essentially separating each level by "\". I was incorrect to state that it had to be done tabular editor only! Thank you @mnedix
I discovered it myself by accident some time ago :D Microsoft has done this functionality very strangely and communicates it poorly. If you don't know it exists, it's hard to guess that it can be done.
It’s also worth noting you can have the same measure appear in multiple folders/sub-folders by using semi-colon “;” as a separator. It can be in two places at once!
All due respect to the effort you put in this video but this is not a hack nor something new. You can do the same without Tabular Editor, you simply have to put the desired path in the Display Folder section in Model view -> Tables using the "\" character. In your example, let's say we have a measure YT_measure; if we wanted to put this in a new folder called YT and this new folder to be created in your Rolling Total folder from the Calculations table then we would simply put "Rolling Total\YT in the Display Folder for this measure. PowerBI will automatically create the new folder for you. Moreover, any other measure you have in your Calculations table can be dragged and dropped into the new folder. The only thing you cannot (yet) do is moving a folder with drag'n'drop (you need Tabular Editor for that).
You are spot on and I appreciate you sharing this feedback! You are completely correct Folder\Folder\Folder works just the same, I'm going to update the description to include this. Very much appreciate this feedback!
I updated the video description to have this disclaimer. Thank you again for sharing this feedback! NOTE!! -- this CAN also be accomplished without Tabular Editor (Natively) by changing the Display Folder to Folder\Folder\Folder, essentially separating each level by "\". I was incorrect to state that it had to be tabular editor only!
I know others already told you how unnecessary this clip is, but here's another advice: drop the clickbaity title and stop pounding the length of this clip going over same stuff over and over. You need 3 minutes to even start the thing. 😅
NOTE!! -- After posting I learned that Folder Hierarchy CAN also be accomplished natively in PBI without Tabular Editor. You can perform this by changing the Display Folder to value Folder\Folder\Folder, essentially separating each level by "\". I was incorrect to state that it had to be done tabular editor only! Thank you @mnedix
Man, not taking offense in me correcting some stuff in your video make me appreciate your work and effort even more than before :)
I discovered it myself by accident some time ago :D Microsoft has done this functionality very strangely and communicates it poorly. If you don't know it exists, it's hard to guess that it can be done.
@@BartoszWegrzyn7N totally agree and I appreciate you sharing your experience as well!
came to say this! Why they dont make it easier to discover is beyond me.
It’s also worth noting you can have the same measure appear in multiple folders/sub-folders by using semi-colon “;” as a separator. It can be in two places at once!
All due respect to the effort you put in this video but this is not a hack nor something new. You can do the same without Tabular Editor, you simply have to put the desired path in the Display Folder section in Model view -> Tables using the "\" character. In your example, let's say we have a measure YT_measure; if we wanted to put this in a new folder called YT and this new folder to be created in your Rolling Total folder from the Calculations table then we would simply put "Rolling Total\YT in the Display Folder for this measure. PowerBI will automatically create the new folder for you. Moreover, any other measure you have in your Calculations table can be dragged and dropped into the new folder. The only thing you cannot (yet) do is moving a folder with drag'n'drop (you need Tabular Editor for that).
You are spot on and I appreciate you sharing this feedback! You are completely correct Folder\Folder\Folder works just the same, I'm going to update the description to include this.
Very much appreciate this feedback!
I updated the video description to have this disclaimer. Thank you again for sharing this feedback!
NOTE!! -- this CAN also be accomplished without Tabular Editor (Natively) by changing the Display Folder to Folder\Folder\Folder, essentially separating each level by "\". I was incorrect to state that it had to be tabular editor only!
@@hyperadapted this channel is awesome. You should most defiintely NOT avoid it.
I know others already told you how unnecessary this clip is, but here's another advice: drop the clickbaity title and stop pounding the length of this clip going over same stuff over and over. You need 3 minutes to even start the thing. 😅
Thanks for sharing and I appreciate your feedback!
This does change EVERYTHING! 😮