Not sure which ways you've tried that hasn't worked but I would start with making sure all your tags are in order. After that's done, you need to tell Musicbee how to handle those tags/display those albums.
Do you want all your compilations sorted together in the same place or do you want to put them in sub-categories? For example, if I have a various artists album with just christmas songs - I change the album artist tag to "Christmas". If it's a soundtrack that's compiled of different artist and not one single composer - I set the album artist to "Soundtrack". This is also done at a folder level where each sub-category gets its own folder, e.g "VA-Christmas" while all my regular albums goes into "Artist A-Z". Those folders are then included in my monitored folders and added to my library.
Another thing you can do is share how you display your library currently and how you've decided to sort it. If you sort by "Artist" and not "Album Artist", then various artists albums will of course be displayed as a separate albums. If there's 25 different artist on a compilation - you will end up with 25 different album entries even though it's all one album.