Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The 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.

Reply
Maha16
Frequent Visitor

Formatting changes for Slicer of type tile

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 . 

 

1 ACCEPTED SOLUTION
v-linyulu-msft
Community Support
Community Support

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:

vlinyulumsft_0-1726747087041.png

After selection:

vlinyulumsft_1-1726747087042.png

You can modify this background colour in the following location:

 

vlinyulumsft_2-1726747130416.png

 

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:

vlinyulumsft_3-1726747130416.png

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])

vlinyulumsft_4-1726747165862.png

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:

vlinyulumsft_5-1726747239026.png

vlinyulumsft_6-1726747239028.png

Here is the final result, which I hope will be helpful to you:

 

vlinyulumsft_7-1726747252193.png

vlinyulumsft_8-1726747252193.png

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.

 

View solution in original post

2 REPLIES 2
v-linyulu-msft
Community Support
Community Support

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:

vlinyulumsft_0-1726747087041.png

After selection:

vlinyulumsft_1-1726747087042.png

You can modify this background colour in the following location:

 

vlinyulumsft_2-1726747130416.png

 

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:

vlinyulumsft_3-1726747130416.png

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])

vlinyulumsft_4-1726747165862.png

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:

vlinyulumsft_5-1726747239026.png

vlinyulumsft_6-1726747239028.png

Here is the final result, which I hope will be helpful to you:

 

vlinyulumsft_7-1726747252193.png

vlinyulumsft_8-1726747252193.png

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.

 

lbendlin
Super User
Super User

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.

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.