Button to modify matrix row structure

[MaxItaly]

Hi,

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.

[v-piga-msft]

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,

Cherry

[MaxItaly]

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.