Forum Discussion
Helper IMap not affected by slicer
Hello there,
I have a very simple data model with 2 tables and a 1 to many relationships. One of the tables contains Lat/Long values - the other contains a grouping category based on the ID.
The issue is that selecting an item from the "Category" filter using ChicletSlicer or the built-in Slicer does not trigger an update of values in the map. (All of the values are still displayed). The strange thing is that by clicking on a location on the map, it filters the category so this means the relationship works.
Does anyone know what is going on? I have double checked the "Edit interactions sections" and everything is set to respond.
PowerBI Dashboard here: https://1drv.ms/u/s!Avv4DxzuMuq2kIFAh4B_rA3wx-bUqg?e=kK7b0V
Screenshots below:
1. Create a new Calculated Table:
Category = DISTINCT('Grouping'[Category])2. Create a new Calculated Column in your grouping table:
Category Count = 1
3. Add a relationship between the new Category table and the Grouping table.
4. Add the Category Count to the map (size?)
5. Change the Slicer to the new Category table.
Here is the pbix.
Cheers,
Nathan
9 Replies
rvceddThe number of matches should not affect the overall behaviour - this would be classed as a bug. Even if there was a single category in one of the tables and it only matched 1 entry in the other table this should still work. The fact that clicking on the map filters the category demonstrates that this is working.
In any case, I have updated the data model and only included a small subset of the data. The same behaviour exists.
Updated dashboard, same problem: https://1drv.ms/u/s!Avv4DxzuMuq2kIFBzqEVwHB2mn49mQ?e=HasYEo