Forum Discussion
Conditionally show columns
You guys were so awesome yesterday, and I hate to bother you again so soon, but I have another need that is too advanced for this beginner.
I have a matrix visual that has 3 columns broken out by month. I need to be able to display it in hours or minutes. I have both hours and minutes in the TIMETABLE, and was hoping to drive it with a slicer to pick Hours or Minutes.
I know I could just create a 2nd page and label them Hours and Minutes, but it would be cool and more user friendly if it could be driven by a slicer. :-) Of course the column headings would also have to reflect the choice.
Hello Anonymous
You could do it using bookmarks. Basically you have both views on your page then show one and hide one with a bookmark, then when they click the other button you hide the first and show the second visual.
There is a good video on bookmarks from Guy in a Cube.
https://www.youtube.com/watch?v=_Afcj8mT5_Q
Also, I attached a sample workbook that has some bookmarks set up that show the visuals swapping when you click on a button. You have to CTRL+Click when working with the buttons in PowerBI desktop but when the report is published you just click the button.
1 Reply
- jdbuchanan71
Super User
Hello Anonymous
You could do it using bookmarks. Basically you have both views on your page then show one and hide one with a bookmark, then when they click the other button you hide the first and show the second visual.
There is a good video on bookmarks from Guy in a Cube.
https://www.youtube.com/watch?v=_Afcj8mT5_Q
Also, I attached a sample workbook that has some bookmarks set up that show the visuals swapping when you click on a button. You have to CTRL+Click when working with the buttons in PowerBI desktop but when the report is published you just click the button.