Forum

Notifications
Clear all

Legend changes when filtered

2 Posts
2 Users
0 Reactions
275 Views
(@jgallion)
Posts: 1
New Member
Topic starter
 

Hello.  I used the "How to Build Interactive Dashboards" you tube video and everything worked great until I went to use the Slicers.  In the video the instructor says to create a manual legend in the Dashboard.  That is fine but, when I slice the data the colors change in each of the charts.  Any ideas how I can set it up so that the colors remain consistent when I use the Slicer?  

 
Posted : 27/08/2021 11:12 am
(@catalinb)
Posts: 1937
Member Admin
 

Hi Julie,

The problem is explained here: https://peltiertech.com/pivot-chart-formatting-changes/

You will also find some workarounds there.

 
Posted : 29/08/2021 1:05 am
Share: