Row missing in visualizations

[TechJoe]

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?

[v-rongtiep-msft]

Hi @TechJoe ,

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

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]

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]

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.

[az38]

@TechJoe 

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

[TechJoe]

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.