Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi Super Users,
I have created a table with the help of Enter Data in Power BI Desktop.
When I apply table visuals then it shows relevant data, however when I turn it into Slicer then it shows one Blank and rest items also show in slicer.
Please advise me why it is showing blank in slicer. Pease refer to screen shot for your reference. I am getting Blank in Slicer as per screen shot 3.
Thank you
Screen shot 3
Solved! Go to Solution.
Hi @Aamir2021 ,
Power BI adds an automatic blank row to any table that is connected to another one and there is a relationship between the two, and there are missing keys in the one that is on the one side of the relationship.
Table1:
Table2:
Relationship:
Table1 is missing data from Table2 and Blank() appears.
You can leave Blank() next to Filter to not display it.
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Aamir2021 ,
Power BI adds an automatic blank row to any table that is connected to another one and there is a relationship between the two, and there are missing keys in the one that is on the one side of the relationship.
Table1:
Table2:
Relationship:
Table1 is missing data from Table2 and Blank() appears.
You can leave Blank() next to Filter to not display it.
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
have you linked this table to another table? if you have the slicer will return blank because your tabledetails does not have all the values for the table that you have linked to, can you share your data?
Proud to be a Super User!
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
60 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |