Forum Discussion
Solved
Show items with no data when filtering by field
Is there a way of filtering using a field but still keep showing items which don't have a value for that field?
I have prepared a quick dummy test:
On the left, when i filter by "indicator name" by 'This' and 'that' values, countries with no data on either categories disappear. On the right, when it's not filtered, we see other countries even if they have no data. My problem is that I actually have a hundred indicators, that is why i need to filter that.
'Show items without data' has been already marked.
Is there a way around the filter to show all countries?
Data model:
The pbix can also be downloaded here:
Horaceman , Try adding +0 to your measure.
1 Reply
- amitchandak
Super User
Horaceman , Try adding +0 to your measure.