Forum Discussion

KR300's avatar
KR300
Helper III
1 year ago
Solved

How to Highlight Max Value / Max String with diff color in the Slicer Visual

Hi All, 

I have a static table like below.

ID              Name

1               SFP.R.11.1

2               SFP.R.11.2

...

...

11             SFP.R.11.11

12               SFP.R.12.1

13               SFP.R.12.2

14               SFP.R.12.3

....

...

22               SFP.R.12.11

23               SFP.R.13.1

24               SFP.R.13.1

...

..

33               SFP.R.13.11

 

The Field in Slicer visual is Name

Latest value is Now SPF.R.13.1 ( I want show this value alone in the Slicer with Green Color which means this is the latest Value )

If Static table will be updated Manually. If someone enters ( Id=44 Name=SFP.R.14.1   i want to show latest value is SFPR.14.1 with Green Font Colour or  Background Colour.

 

So I want to show this as Dynamic whenever there will be a update in the Statci Table.

  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi KR300 ,

    As Ibendlin said, there is no way to apply conditional formatting directly to the slicer. You can create a table visual and apply conditional formatting to it to fulfill your needs. The steps are as follows:
    1. Create the following measure

    Conditional formatting = 
    VAR _selid =
        SELECTEDVALUE ( 'Table'[ID] )
    VAR _maxid =
        CALCULATE ( MAX ( 'Table'[ID] ), ALL ( 'Table' ) )
    RETURN
        IF ( _selid = _maxid, "Green" )

    2. Create a table visual and go to the filter panel and set it up as shown below.

    3. Apply conditional formatting to the above table visual.

    Best Regards

  • KR300 Please confirm: do you really need a slicer with just one value on it? can it be resolved with another type of visualization object? If so, I suggest to build the Latest Value measure shown below and used in a CARD (and formatting as needed)  

    Latest Value = 
    	SELECTCOLUMNS(
    		FILTER(
    			'Table',
    			'Table'[ID] = MAX('Table'[ID])
    		),
    		'Table'[Name]
    	)

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

    Kudos are accepted😀

4 Replies

  • KR300 Please confirm: do you really need a slicer with just one value on it? can it be resolved with another type of visualization object? If so, I suggest to build the Latest Value measure shown below and used in a CARD (and formatting as needed)  

    Latest Value = 
    	SELECTCOLUMNS(
    		FILTER(
    			'Table',
    			'Table'[ID] = MAX('Table'[ID])
    		),
    		'Table'[Name]
    	)

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

    Kudos are accepted😀

    • KR300's avatar
      KR300
      Helper III

      pcoley , I want all the values appear in the slicer with Highest value as a Green & Bold Color.

       

      Workaround: Show highest value when hovering the Slicer ( So that user can see what is the Highest version )

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi KR300 ,

    As Ibendlin said, there is no way to apply conditional formatting directly to the slicer. You can create a table visual and apply conditional formatting to it to fulfill your needs. The steps are as follows:
    1. Create the following measure

    Conditional formatting = 
    VAR _selid =
        SELECTEDVALUE ( 'Table'[ID] )
    VAR _maxid =
        CALCULATE ( MAX ( 'Table'[ID] ), ALL ( 'Table' ) )
    RETURN
        IF ( _selid = _maxid, "Green" )

    2. Create a table visual and go to the filter panel and set it up as shown below.

    3. Apply conditional formatting to the above table visual.

    Best Regards