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.
hi,
lately also i'm getting an extra (Blank) line item in almost all of my slicer as per screenshots below:
[an example of dropdown menu in power bi service]
[an example of dropdown menu in power bi desktop]
i have also found that when analyzing the data model in ms excel as follows:
[example from dropdown menu in ms excel pivot table]
i have been running this data model for few months without such case unti recently. kindly advise on how to resolve this.
tks & krgds, -nik
Solved! Go to Solution.
@Anonymous , There can be few reasons behind it. Please refer to this blog for that
https://blog.crossjoin.co.uk/2019/07/10/power-bi-slicers-show-values-that-do-not-exist/
https://www.youtube.com/watch?v=23qemkDqMVY
https://exceleratorbi.com.au/rename-blank-in-a-slicer-in-power-bi/
If this does not help to fix, You can remove the blank by using visual level filter
@Anonymous , There can be few reasons behind it. Please refer to this blog for that
https://blog.crossjoin.co.uk/2019/07/10/power-bi-slicers-show-values-that-do-not-exist/
https://www.youtube.com/watch?v=23qemkDqMVY
https://exceleratorbi.com.au/rename-blank-in-a-slicer-in-power-bi/
If this does not help to fix, You can remove the blank by using visual level filter
many thanks again, @amitchandak .
i have managed to resolve the 'blank'-item in slicer as per suggested resolution in https://www.youtube.com/watch?v=23qemkDqMVY vdo.
krgds, -nik
Thanks for Confirmation
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 | |
97 | |
79 | |
73 | |
56 |
User | Count |
---|---|
145 | |
105 | |
104 | |
90 | |
63 |