Measure Overflow

[ryans]

Anyone have any advice on how to manage lots of measures? What I mean is that I have lots of them and they do not stand out as much as I would like in the field list. I wish they were all collected in one space and potentially could be highlighted different colors. In the absense of that functionality, what do you do?

[Greg_Deckler]

Well, there aren't really any great options and this depends on whether your woes are in data model, report or both. data model sorts the measures in creation order. Report sorts alphabetically. So, you can group things in Report mode by doing things like putting varying numbers of "_" in the beginning of the name. Like I said, not great, but something.

[greggyb]

Measures can be defined in any table. In Power BI it makes absolutely no difference whatsoever what table a measure is defined in.

You can use empty tables as a sort of pseudo-folder. Create some empty queries in Power Query with reasonable names, load them to the model, and create your measures in those tables.

You can do this in an existing model and just alter the table that a measure is defined in