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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
TechJoe
Frequent Visitor

Row missing in visualizations

Hey Guys, I am having a strange issue here.
I have a table named Product Category with 3 columns and 4 Rows. The rows are; Bikes, Components, Clothing and Accessories.There are no filters on the table. Now when I try to create a visualization, Components is missing. However, Components is listed up in the basic filtering section with the other 3 rows.
The total rows is 606. What could I possibly be doing incorrectly?

5 REPLIES 5
v-rongtiep-msft
Community Support
Community Support

Hi @TechJoe ,

If you don't want to make use of the primary key, then you'll need to select Don't summarize.

11.PNG

 

Best Regards

Community Support Team _ Polly

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-rongtiep-msft
Community Support
Community Support

Hi @TechJoe ,

Has  your problem be solved? If not, please provide some screenshots foe more details.

 

Best Regards

Community Support Team _ Polly

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

Ashish_Mathur
Super User
Super User

Hi,

Check for Page level or report level filters.  If you are still unable to resolve, then share the download link of the PBI file.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
az38
Community Champion
Community Champion

@TechJoe 

maybe these Components rows just have no data in other columns and flag "show items with no data" is false?


do not hesitate to give a kudo to useful posts and mark solutions as solution
LinkedIn
TechJoe
Frequent Visitor

Thank you for the response.

This Components row has a category key number. Inside its subcategory, it has visible data. The data is also visible in the excel file. It just disapears in visualization. 

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors