Hi everyone,
I'm working on a questionnaire response report that I have to translate into about 7 languages. I'm (obviously) using lots of field parameters. My basic data model consists of a bunch of measures, and (dim)tables that look like this:
ID label_en label_es label_fr
etc.
I'm using field parameters hooked up to my language table to switch between the columns for display names and measures to count or sum or whatever.
My issue has nothing to do with my data model but with formatting:
When I use visuals that apply custom colors to for instance bars, as in the 100% stacked bar chart, the colors don't "stick" when I switch the language. E.g. I have categories "none", "a little", "a lot", "I don't know" and all corresponding translations in their respective columns. I will set the colors the way I like them (the way the client wants because of house styling), switch to another language and I have to do it all over again.
Does anyone know a way around this? I have a whole bunch of visuals and 7 languages to tackle and that is a lot of finicky work that's very error prone. Thanks in advance!
