Forum Discussion
Table goes blank after selecting postcode from map visual and then from slicer
Hi Experts,
I have report where I have shape map visual showing data by postcode, a table having postcode as one of the columns and a Postcode slicer.
When I select a geographical area on the map, the table shows the data correctly for the selected poscode.
However, when I select a different postcode from the slicer the table goes blank.
When I checked the table filters, it shows both the postcodes selected from map and from the slicer.
Shouldn't the table show the data for both the postcodes as a normal behaviour?
Hi Anonymous
When you select two post codes from different visuals, it means that these two filters should be met at the same time. However, one area only has one post code. As a result, it displays blank as no area can meet both filters at the same time.
If you want to show two areas' data in the table visual, you can select two post codes from the slicer at the same time.
For example, when you select multiple values from a slicer, it applies only a filter on the visual with "," token between values.
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
1 Reply
Hi Anonymous
When you select two post codes from different visuals, it means that these two filters should be met at the same time. However, one area only has one post code. As a result, it displays blank as no area can meet both filters at the same time.
If you want to show two areas' data in the table visual, you can select two post codes from the slicer at the same time.
For example, when you select multiple values from a slicer, it applies only a filter on the visual with "," token between values.
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.