Yvonne Love
Member
Hi all! I'm still relatively new to Power BI though I have been exploring a lot this past week.
1) When creating a button and assigning an action (for my report, it's selecting a bookmark), is there a way to format the button when it has been pressed? I see On Hold and On Press as options for formatting, which do work, but it clears formatting after I stop pressing. Ideally I would like the selected button to remain formatted when pressed so the user knows which set of data they are viewing. I can't use a slicer in this case because the data is in two separate columns and is therefore, two separate series.
2) I have data which I am summarizing by location; however, in my data set, there are two separate locations - one for our attorneys and one for our offices; likely, in the majority of cases, they will be the same, but in many cases they won't be. So I have a slicer set up based on attorney location, and I have created a column chart showing top 10 clients by attorney. Is there a way to use that same slicer to show top 10 clients by office as well? It seems like that may be too complicated, so I may have separate tabs for attorney and office, but I did want to see if there may be a way to do that.
Thank you!!
Yvonne
1) When creating a button and assigning an action (for my report, it's selecting a bookmark), is there a way to format the button when it has been pressed? I see On Hold and On Press as options for formatting, which do work, but it clears formatting after I stop pressing. Ideally I would like the selected button to remain formatted when pressed so the user knows which set of data they are viewing. I can't use a slicer in this case because the data is in two separate columns and is therefore, two separate series.
2) I have data which I am summarizing by location; however, in my data set, there are two separate locations - one for our attorneys and one for our offices; likely, in the majority of cases, they will be the same, but in many cases they won't be. So I have a slicer set up based on attorney location, and I have created a column chart showing top 10 clients by attorney. Is there a way to use that same slicer to show top 10 clients by office as well? It seems like that may be too complicated, so I may have separate tabs for attorney and office, but I did want to see if there may be a way to do that.
Thank you!!
Yvonne