When you assign default colors to your parameter-driven dimension, do you assign colors for the domain produced by the current parameter value, click OK, select the next parameter value, assign colors for this domain, and repeat until you've assigned colors for each parameter selection?
Yes, that's what I was doing. I didn't always assign every value individually, as that includes 200+ country names.
In case it made a difference, I edited the field (knowing I could later change it back) so all the field values were in the domain at once
//All values in domain at once
WHEN 1 THEN [Service Name]
WHEN 2 THEN [Channel]
WHEN 3 THEN [Service Type]
WHEN 4 THEN [Product Name]
WHEN 5 THEN [Location (P:)]
//CASE [Parameters].[Revenue Segmentation]
// WHEN "Individual Service" THEN [Service Name]
// WHEN "Channel" THEN [Channel]
// WHEN "Service Type" THEN [Service Type]
// WHEN "Product" THEN [Product Name]
// WHEN "Location" THEN [Location (P:)]
But even then when I published the datasource to the server, color values still reverted.
Have you tried this way.
- You publish your datasource once.
- You create your workbook using published datasource and finalize all colors.
- Also, now you also got a new local copy of data now which you publish to datasource replacing your old datasource or updating it if you are using shared drive.
- Now, you replace the datasource in your workbook with the newly published data source.
- Colors and filters will stay when you would this.