Forum

Notifications
Clear all

Wrong colors with slicers

4 Posts
3 Users
0 Reactions
156 Views
(@lili)
Posts: 2
New Member
Topic starter
 

How come the colors in my dashboard are all green (and do not correspond to the legend colors)  when I use the slicers (see animated GIF). What have I done wrong ?

Thanks a lot for your help !

Animated Gif

 
Posted : 18/03/2024 4:58 pm
(@catalinb)
Posts: 1937
Member Admin
 

Hi Lili,

Colors in pivot tables are not working the same way as regular charts, this might help:

https://peltiertech.com/pivot-chart-formatting-changes/

 
Posted : 21/03/2024 12:05 am
(@lili)
Posts: 2
New Member
Topic starter
 

Thanks a lot ! Very helpful and very clear !

 
Posted : 21/03/2024 5:54 am
(@mynda)
Posts: 4761
Member Admin
 

Hi Lili,

If you clear the slicer selections, then apply your formatting, they should stick. No need to create a duplicate of your PivotTable etc. as described in the article Catalin linked to, although that of course is an option if you prefer.

Mynda

 
Posted : 23/03/2024 12:01 am
Share: