Forum Discussion
Button to change rows in Matrix
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!
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
2 Replies
ArentirResolver III
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
v-cherch-msftMicrosoft Employee
Hi Anonymous
You may have a look at below document.
https://docs.microsoft.com/en-us/power-bi/desktop-bookmarks
Regards,
Cherie