Forum Discussion
Change Hierarchy Column Name in a Matrix
Thank you everyone for your suggested worarounds. And, I especially appreciate the confirmation from Anonymous that the feature does not exist.
The main reason I can't just chuck a rectangle over it is because my visuals are transparent, and that would horribly clash with the background. Furthermore, I re-use the Hierarchy in numerous reports. Thus, the context changes from report to report, and renaming it to something more descriptive for one report would break it for others.
The only real workaround seems to ditch hierarchies and just manually load the levels row by row into your report. Then you have complete control over the title.
It's not a big deal, I just wish I knew this sooner before wasting a bunch of time on it. It's these little things that are frustrating and make PowerBI development into a nightmare. Oh well, you live and learn.
Thank you very much MNedix, ajohnso2 and PijushRoy for your prompt reply.
Unfortunately, there isn't a straightforward way to completely hide or blank out the title of a hierarchy level in a matrix visual. However, here are a few workarounds you might consider:
You can create a transparent shape (like a rectangle) and place it over the hierarchy title. This won't remove the title but will effectively hide it from view.
Instead of trying to remove the title, consider renaming it to something more relevant or descriptive for your report. This way, it can still serve a purpose without being distracting.
You can propose an idea about this, you can submit your idea by going to the link below:
Regards,
Nono Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you everyone for your suggested worarounds. And, I especially appreciate the confirmation from Anonymous that the feature does not exist.
The main reason I can't just chuck a rectangle over it is because my visuals are transparent, and that would horribly clash with the background. Furthermore, I re-use the Hierarchy in numerous reports. Thus, the context changes from report to report, and renaming it to something more descriptive for one report would break it for others.
The only real workaround seems to ditch hierarchies and just manually load the levels row by row into your report. Then you have complete control over the title.
It's not a big deal, I just wish I knew this sooner before wasting a bunch of time on it. It's these little things that are frustrating and make PowerBI development into a nightmare. Oh well, you live and learn.
Can you tell me if your problem is solved? If yes, please accept it as solution.
Regards,
Nono Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.