Select All in a Power BI Slicer–#SQLNewBlogger
source link: https://voiceofthedba.com/2022/11/09/select-all-in-a-power-bi-slicer-sqlnewblogger/
Go to the source link to view the article. You can view the picture content, updated content and better typesetting reading experience. If the link is broken, please click the button below to view the snapshot at that time.
One of the things I’ve been working on this year is a Power BI report for the kids I coaco in volleyball. As a part of this, I want to be able to show all kids, or a few kids, in relation to each other.
This post covers enabling this for a Slicer on a report.
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. Here are some hints to get started.
Adding the Slider
I have a basic report with a line graph. It looks like this once I’ve added in the value to capture at the Y, the date as the X, and the player as the legend.
I’ll add a slicer to the report and drop the players in there. I see the players, but I don’t have an easy way to select all of them.
I can select 1, but if I select another, the report changes. I can CTRL+select to get multiple players, but I want to easily get everyone.
I knew this was possible because I’d seen other reports show this. I didn’t see anything obvious, so I actually had to search the docs and found a note that explained how to enable this.
If I click the slicer, I can then select the Format option on the right, which is the center icon at the top of the visuals pane. You can see the tool tip below.
Once I do this, I need to expand the Slicer Settings and then the Selection area, as shown here.
Now I want to click the “Show Select All” button.
Now my slicer show a Select All at the top.
Easy.
I found that when I have a few slicers, which I wanted for this report, it was easy to add them all, then do the formatting for one. If I clicked another slicer, I was in the same format spot and could enable SELECT ALL for the next one. For me, I actually had 3 slicers, so it was nice to format them all very quickly to add this option.
SQL New Blogger
This is a really basic post, but it was also something that I didn’t intuitively figure out. I had to research a bit and look around. That’s the skill that many employers need and want.
This also might trigger someone to ask me about Power BI and what I know, which gives me the chance to talk about the learning and experimenting I’ve done.
You could do this as well. It took me about 15-20 minutes to grab screen shots and write this.
Recommend
About Joyk
Aggregate valuable and interesting links.
Joyk means Joy of geeK