Forum Discussion
Measure unaffected by Filled Map while column chart is affected
Hi all!
I've got a page on my report that contains two things;
1. a Filled map on which you can select countries
2. A stacked column chart that changes based on country selected by the Filled map.
This currently works with no issues. If I select a country on the map the total bar on the chart goes transparent and the part of the bar for the specific country stays normal.
Now I wanted to add something to this, I wanted the bars on the chart to be gradiently colored by a value (Error Rate). 100% Error Rate would be Red and 0% would be Green. This is where I ran into trouble, I got the color gradient to work, but only for the total. If I select a specific country on the map the non transparent bar on the chart shrinks but the color and error rate stay the same as the total bar.
The bars on the chart are affected by the filter from the map but the measure just completely ignores the filter. The Measure does work when I make a slicer next to the map and then select a country from there. This isn't the solution I want though, cause that way I cant see the whole map, just the part selected by the slicer. Same goes for the column chart, if I select a country this way I only get to see the data for that country, no transparant total column.
Here's the code for the measure, it's quite simple so I'm surprised it ignores the filter.
1 Reply
- v-yuta-msft
Community Support
Anonymous ,
Generally, have you tried visual level filters? If you still can't solve this problem, please share some sample data and show what the visuals look like.
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.