Forum Discussion
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.
- Anonymous1 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 measureConditional 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
- lbendlinSuper User
not currently possible. If this is important to you please consider voting for an existing idea or raising a new one at https://ideas.fabric.microsoft.com
- pcoleySuper User
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😀
- AnonymousNot 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 measureConditional 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