Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Aamir2021
Advocate I
Advocate I

Getting Blank in Slicer Visuals

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

Aamir2021_0-1668454520385.png

Aamir2021_1-1668454577587.png

Screen shot 3

Aamir2021_2-1668454593344.png

 

1 ACCEPTED SOLUTION
v-yangliu-msft
Community Support
Community Support

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:

vyangliumsft_0-1668497097089.png

Table2:

vyangliumsft_1-1668497097091.png

Relationship:

vyangliumsft_2-1668497097093.png

Table1 is missing data from Table2 and Blank() appears.

vyangliumsft_3-1668497097093.png

You can leave Blank() next to Filter to not display it.

vyangliumsft_4-1668497097095.png

 

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.

 

View solution in original post

2 REPLIES 2
v-yangliu-msft
Community Support
Community Support

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:

vyangliumsft_0-1668497097089.png

Table2:

vyangliumsft_1-1668497097091.png

Relationship:

vyangliumsft_2-1668497097093.png

Table1 is missing data from Table2 and Blank() appears.

vyangliumsft_3-1668497097093.png

You can leave Blank() next to Filter to not display it.

vyangliumsft_4-1668497097095.png

 

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.

 

vanessafvg
Super User
Super User

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?





If I took the time to answer your question and I came up with a solution, please mark my post as a solution and /or give kudos freely for the effort 🙂 Thank you!

Proud to be a Super User!




Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.