Forum Discussion

Anthea's avatar
Anthea
Frequent Visitor
7 years ago
Solved

No data showing in visuals although it is in Query Editor

  Hello I have uploaded a new xlsx file (same as all my otehr data sources) and although the data looks fine when I view it in Query Editor, the moment I go to create a visual it recognis...
Need Help
  • ibarrau's avatar
    ibarrau
    7 years ago

    Check if you have a page or report level filter you are not seeing. If you are using a regular visual from power bi and not a custom visual, then I think it could be a bug. Please update your Power Bi Desktop to the lastest version August 2019.

    https://www.microsoft.com/en-us/download/details.aspx?id=58494

     

    Regards,

ibarrau's avatar
ibarrau
Icon for Super User rankSuper User
7 years ago

Ok. Column it is. Are ou sure you have the values on the visualization aggregated like this:

 

Screenshot of the chart, Visualizations pane and Fields list with Sum called out.

 

You may have it in "Don't summarize"

Regards,

Anthea's avatar
Anthea
Frequent Visitor
7 years ago

This is what I have

 

  • ibarrau's avatar
    ibarrau
    Icon for Super User rankSuper User
    7 years ago

    You have a lot of tables right there. Are you sure the fields of the visualization are on the same table? it seems like they are from two tables that are related but there is no match between them.

     

    Can you tell us the name of the tables containin the columns and how they are related?

     

    Regards,

    • Anthea's avatar
      Anthea
      Frequent Visitor
      7 years ago

       

      These are on the same table:

       

      What do you mean by the name of the tables and how they are related?

       

       

      • Ronald123's avatar
        Ronald123
        Icon for Resolver III rankResolver III
        7 years ago

        Anthea ,

         

        Is there any value when you drag the column Sales @ OP into a card visual?

        Greetz,

         

        Ronald