Forum Discussion

TechJoe's avatar
TechJoe
Frequent Visitor
4 years ago

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?

Need Help

5 Replies

  • az38's avatar
    az38
    Community Champion
    4 years ago

    TechJoe 

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

    • TechJoe's avatar
      TechJoe
      Frequent Visitor
      4 years ago

      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. 

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    4 years ago

    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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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.

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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.