Forum Discussion
Two issues: Relationship between tables and shape map dynamic fill colors. Need Help.
The Shape Map is a preview item, and I guess there are some bugs with it still as there is not a function option on the fill colors. I did find that if I create the map as a filled map with a function for the fill colors, I can THEN change it to a Shape Map and the function option will remain. However, it doesn't work if you create the Shape Map, change it to a Filled Map, use the function option and then change it back to a Shape Map. You have to start it as a Shape Map.
Hi gaylagarrett ,
Regarding your first question, what is your requirement? To filter the number of questions and active users in the same month by month?
Regarding your second question, I found that the visual can only set static values. There should be an option fx for conditional formatting.I think the visual you are using now does not support your needs.Do you accept to change the visual object to 'matrix'?
On the first question, I need to be able to calculate the ratio of issue volume by the average active accounts for a time period, in year increments. The date filter will be by year.
On the second question, I want a map that shows by color fill what states have the highest ratio of issue volume to active accounts for a time period. The shape map does not have the function/fx capability, but I think that there could be a way to create a measure that dynamically forces the "ranking" of issue volume to active accounts ratio to a normalized number (between 1 and 2 maybe), and then use that measure as the color fill value. So out of 50 states, no matter what filters are selected they would have a ratio normalized between the numbers 1 and 2 (1.1, 1.2, 1.6, etc.) and then I can select 1 as the minimum color value, 1.5 as the center and 2 as the maximum.
The Shape Map is a preview item, and I guess there are some bugs with it still as there is not a function option on the fill colors. I did find that if I create the map as a filled map with a function for the fill colors, I can THEN change it to a Shape Map and the function option will remain. However, it doesn't work if you create the Shape Map, change it to a Filled Map, use the function option and then change it back to a Shape Map. You have to start it as a Shape Map.