Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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:
Solved! Go to Solution.
@Horaceman , Try adding +0 to your measure.
@Horaceman , Try adding +0 to your measure.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
100 | |
78 | |
76 | |
52 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |