Button to change rows in Matrix

[Anonymous]

I have a Matrix that is a budget to actual variance. The matrix seems to be working but once i created the measures to calculate the variance, i lost the ability to right click on my actuals and "see records". Not sure why this occurs after i added the measure, if i delete the measure from Values, i can then see records.

ValuesWith measureWithout Measure

My idea to fix this was to add a button that would take that measure out once clicked, is that possible? I dont have much experience with Power BI buttons. 

Thanks!

[v-cherch-msft]

Hi @Anonymous

You may have a look at below document.

https://docs.microsoft.com/en-us/power-bi/desktop-bookmarks

Regards,

Cherie

[Arentir · Accepted solution]

Hi @Anonymous

You can do that using bookmarks.

1) Create two charts and two buttons, one with your measure and one without

2) Create two bookmarks, each would display only one of the graph and one of the button. Remove "Data" from your Bookmark. "Display" is what matters here

3) Associate the bookmarks to your buttons

and voila. Hope this helps