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 All,
I see a blank value appear on the slicer from a dimension column (i manually created the Dimension table) only when i connect it to the fact table in the data model.
This is causing an issue in my measure on the Fact table. Is there a reason for the Blank to appear on my slicer ?
How can i avoid it ?
Thank you.
Solved! Go to Solution.
@sd782 it might be because you have values in your fact table thar are not in the slicer.
See the following example.
As J and K are not on Slicer 1 it is automatically showing a blank. It doesnt happen for Slicer 2 as it includes all the Prod. in fact table.
In this situation you need to be careful if you filter the visualization or page by removing the blank because it will "remove" J and K from the table.
@sd782 it might be because you have values in your fact table thar are not in the slicer.
See the following example.
As J and K are not on Slicer 1 it is automatically showing a blank. It doesnt happen for Slicer 2 as it includes all the Prod. in fact table.
In this situation you need to be careful if you filter the visualization or page by removing the blank because it will "remove" J and K from the table.
@BordalosThank you for your inputs. I was able recreate and verify what you said.
Can you create another product table with just those products and use that for slicer 1 and use the base table for slicer 2?
What about using a page level filter for products marking it as is not blank?
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 |
---|---|
106 | |
93 | |
75 | |
62 | |
50 |
User | Count |
---|---|
147 | |
107 | |
105 | |
87 | |
61 |