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 ,
I notice Blank as an option in the Slicer Values list or dropdown when actually the data does not have a blank value.
I noticed this in the october and also in Novemebr 2017 release.
The left is a slicer and the right is table visual.
Can somebody share how to get rid of the Blank appearing, as slicers do not have visual filtering option.
if it is a bug then Power bi team should act on it fast.
Thanks
CheenuSing
Solved! Go to Solution.
Hi @CheenuSing,
if your relationship tables contains records who can't correct mapping to related table, it will shows value as 'blank' option in slicer.(blank option means the missing records)
Regards,
Xiaoxin Sheng
Hi @CheenuSing,
if your relationship tables contains records who can't correct mapping to related table, it will shows value as 'blank' option in slicer.(blank option means the missing records)
Regards,
Xiaoxin Sheng
Hi @v-shex-msft
Thanks for the note.
Just wanted to know how come a date table which is created based on the fact table min and max date, when put on a slicer can have blank as an option. It is understandable that some dates in the date table may not have values in the fact table.
Cheers
CheenuSing
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 |
---|---|
110 | |
97 | |
77 | |
63 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |