Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Used slicer visual of type tile in my power bi report. Got feedback to change slicer formatting in such a way that audience can easily understand which option is selected, unselected in slicer. Slicer of type tile is fixed. We can't change it to any other type. If anyone knows, pls Tell it in detailed manner like first where I need to go, and select which option like that. I don't hav much experience on power bi .
Solved! Go to Solution.
Thanks for the reply from lbendlin , please allow me to provide another insight:
Hi, @Maha16
Regarding the issue you raised, my solution is as follows:
1.Firstly, if you want to know which slicer has been selected and which hasn’t, the most straightforward way is to observe whether the button’s background colour has changed:
Before selection:
After selection:
You can modify this background colour in the following location:
2.Secondly, if you want to see which data in the table has been selected and which hasn’t, you can try the following steps:
For example, my original data is as follows:
Create the following calculated table, extracting the column you use for the slicer and setting it as a slicer,This ensures the slicer does not directly affect the main table.
SCILTER = VALUES('Table'[SCILTER])
Create the following two measures:
selected =
VAR SELECT1 =
VALUES ( 'SCILTER'[SCILTER] )
RETURN
IF ( MAX ( 'Table'[SCILTER] ) IN SELECT1, 1, 0 )
UNselected =
VAR SELECT1 =
VALUES ( 'SCILTER'[SCILTER] )
RETURN
IF ( NOT ( MAX ( 'Table'[SCILTER] ) ) IN SELECT1, 1, 0 )
Apply the measures to two table visuals as filters:
Here is the final result, which I hope will be helpful to you:
Of course, if you have any new ideas, you are welcome to contact us.
Best Regards,
Leroy Lu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks for the reply from lbendlin , please allow me to provide another insight:
Hi, @Maha16
Regarding the issue you raised, my solution is as follows:
1.Firstly, if you want to know which slicer has been selected and which hasn’t, the most straightforward way is to observe whether the button’s background colour has changed:
Before selection:
After selection:
You can modify this background colour in the following location:
2.Secondly, if you want to see which data in the table has been selected and which hasn’t, you can try the following steps:
For example, my original data is as follows:
Create the following calculated table, extracting the column you use for the slicer and setting it as a slicer,This ensures the slicer does not directly affect the main table.
SCILTER = VALUES('Table'[SCILTER])
Create the following two measures:
selected =
VAR SELECT1 =
VALUES ( 'SCILTER'[SCILTER] )
RETURN
IF ( MAX ( 'Table'[SCILTER] ) IN SELECT1, 1, 0 )
UNselected =
VAR SELECT1 =
VALUES ( 'SCILTER'[SCILTER] )
RETURN
IF ( NOT ( MAX ( 'Table'[SCILTER] ) ) IN SELECT1, 1, 0 )
Apply the measures to two table visuals as filters:
Here is the final result, which I hope will be helpful to you:
Of course, if you have any new ideas, you are welcome to contact us.
Best Regards,
Leroy Lu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Got feedback to change slicer formatting in such a way that audience can easily understand which option is selected, unselected in slicer.
What does "easily understand" mean in this context? Did the audience voice any color preferences for selected vs unselected? Usually "selected" is light txt on dark background, and "unselected" dark text on light background.
Maybe show them a couple alternatives, keeping accessibility considerations in mind. Remember there is a "new" slicer visual available with many more options.
User | Count |
---|---|
141 | |
70 | |
69 | |
53 | |
52 |
User | Count |
---|---|
208 | |
94 | |
64 | |
60 | |
57 |