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.
Currently an option is present in the slicer for (blank) when there are no blank rows in my data. I have tried to both filter out all blanks within query and the desktop and have been unsucceful. Using the query I also have selected "remove blanks" with no success.
I am not sure if this is a known bug or if it may be something I am doing! Any comments or tips would be helpful! Thankyou(:
- Austin I
Solved! Go to Solution.
hi, @Anonymous
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)
For example:
and create a relationship between them by "Type"
Then drag "Type" or "Color" into visual, (Blank) will display on slicer.
And If you slicer (Blank), visual will show data that table B can't correct mapping to table A,
here is a similar post for your refer to:
Best Regards,
Lin
hi, @Anonymous
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)
For example:
and create a relationship between them by "Type"
Then drag "Type" or "Color" into visual, (Blank) will display on slicer.
And If you slicer (Blank), visual will show data that table B can't correct mapping to table A,
here is a similar post for your refer to:
Best Regards,
Lin
Hi @v-lili6-msft ,
I have similar case for my data, but I'm sure that all FK in my fact table already exist as PK in the lookup table. When I select <blank> it returns no data.
Is there anyway I can remove this without filtering the <blank> out? I need it there since it is a good indicator for any wrong data input.
Thank you.
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 |
---|---|
104 | |
101 | |
79 | |
72 | |
64 |
User | Count |
---|---|
142 | |
108 | |
101 | |
81 | |
74 |