Is there any option to be able to highlight multiple values in single pivot table without removing other values of the same pivot?
I have filter of field which is used also used in pivot and when user select the values in the filter then pivot should display the selected values as highlighted and also retain non selected values.
I have pivot table which has city and population field. Now when user select Mumbai or Hydrabad then these 2 values gets highlighted along with retaining other values in same table. And the selection of values will be the user's choice.
Please find below example for your reference.
I hope this helps.
do u want this color by user filter selection? or it just static then u can try like below
p.s; just add above code in your City dimension & measure as text color expression then u can get below o/p
another way u can add data island at back check this method
Thanks for the response.
I don't want filter for city. I just wanted to use pivot table where user has access to highlight city/population.
Looking forward for your kind response.
Please add the below expression to both DIMENSION, EXPRESSION --> Text color expression
= If(Wildmatch(Concat(DISTINCT(City), '|'), City ) and GetSelectedCount(City)>0, Red(),black())
Note : Please add the dimension filed to your expression using set analysis