Showing results for 
Search instead for 
Did you mean: 
Helper III
Helper III

Button to modify matrix row structure


I'd like to hear your considerations about how I solved this specific problem.

I have a matrix that has (let's say):

as columns:

  • year → months

as values:

  • sales import, sales quantity

as rows:

  • Client
  • Area
  • Item.

I have been asked to have the possibility to remove the "Sales quantity" or the "Area".

My solution has been the creation of four button images that are linked to a bookmark that shows these matrix:

  •  "Sales quantity" and "Area",
  •  "Sales quantity" but not"Area",
  •   "Area" but not "Sales quantity",
  • nor "Area" nor "Sales Quantity".

It's not quite nice to see, and everytime I press one of these buttons the visual objects are resetted.

I was wondering, is there another way to achieve my scope?

I know there is the possibility to use the SWITCH function to switch a measure, but I guess this is not the case for this to be used, am I right?
I underline that is important that the row dimensions mantain the order I specified: Client, Area, Item.

Many thanks to anyone who may help me.

Resident Rockstar
Resident Rockstar

Re: Button to modify matrix row structure

Hi @MaxItaly,


I have made a test with creating 4 buttons and bookmarks try to get your requirement.


You could Ctrl+click the button, and it will show the corresponding visual.





More details, you could refer to my test pbix file.


For further, you could refer to this video.


Best regards,


Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Helper III
Helper III

Re: Button to modify matrix row structure

Thanks for your reply and the time you spent for answering me,

maybe I've not been quite clear, but that's the kind of solution that I've already implemented.

What I really wanted to ask is if there is another way to achieve this, because the final users don't like this kind of solution.

I am quite sure this is the only one possible way, I just wanted to be sure by asking this to users who have more experience than me.

Helpful resources

Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Upcoming Events

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.


Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors
Top Kudoed Authors