I have a map dashboard of the US, with Alaska, Hawaii, and DC in floating sheets on top. I also have a parameter for selecting which metric to see. The problem is that the colors are not coordinated between each sheet, so when the parameter changes the floating states show up with the darkest color, since there is only one value in the range for that sheet. Essentially, I need the same min/max values applied to all sheets for the color range. I'm assuming I can do this with some sort of fixed calc that gets the range for that parameter, and then put that on the color shelf, I just don't know how to do it. Or if there is a different way I am all ears!
Hi, Jay
Please find my workaround as attached. I just pick below two parameters as example. You could follow the same steps to other parameters.
For AK and HI, I just remove your filter and adjust the map to show these two in the workbook range because there is no other states around.
For DC, you will see there is a DC filter calculation I created. You could apply similar way to AK and HI as well in case the adjust the display area is not suitable workaround.
Workbook attached with version 10.3, please let me know if you have question
ZZ
