Move value fields in matrix dinamically

[oscarmqz]

Hi, is there a way to move the fields in values on a matrix dinamically?

--->

I created a table to show/hide measures dinamically. But I have two problems, 1) Values are hidden but the label and the row stays there (I think there's no solution for this) like the example below, I'm choosing only "column1" value to be displayed. The value goes away but the label is there... So if i cannot hide it, at least I'd like the one being displayed to be shown on the first line. This is because I will have 15 measures there and I don't want to have 15 blank rows and the one I want at the bottom or in the middle.

Any help is appreciated!

Regards

Oscar

[amitchandak]

@oscarmqz , you can change measure inside not the measure

https://community.powerbi.com/t5/Desktop/Slicer-MTD-QTD-YTD-to-filter-dates-using-the-slicer/td-p/50...

If you want to change row or column use bookmarks https://radacad.com/bookmarks-and-buttons-making-power-bi-charts-even-more-interactive

[parry2k · Accepted solution]

@oscarmqz you can hide measures based on your selection, it is a bit of workaround but you can achieve the goal.

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!