Forum Discussion

dramus's avatar
dramus
Icon for Continued Contributor rankContinued Contributor
9 years ago

TopN filter and joins

We have a table with a code value and a numeric field.

 

I can successfully create a TopN Filtered Bar chart on this.

 

However, if I switch the code value field for a description for the code value that is stored in a different table the visualization fails with "Visual has exceeded the available resources". Remove the filter and it displays just fine.

 

Any ideas?

 

Failure message

Need Help

6 Replies

  • BhaveshPatel's avatar
    BhaveshPatel
    Icon for Super User rankSuper User
    9 years ago

    What do you mean by

     

    "if I switch the code value field for a description for the code value that is stored in a different table"

     

    Can you please elaborate this?

  • dramus's avatar
    dramus
    Icon for Continued Contributor rankContinued Contributor
    9 years ago

    Happy to give more details.

     

    We have one Data table and a number of Dimensions tables.

     

    If I use just the Data table, all is good. The TopN performs as expected.

     

    If I use a field from a Dimension table as the category field and a field from the data table as the value field, the visualization gives the above error.

     

    If I remove the TopN filter (i.e. show all the columns) the visualization words with the dimension field on the chart.

    • dramus's avatar
      dramus
      Icon for Continued Contributor rankContinued Contributor
      9 years ago

      Hmmm.....In Power BI Desktop.

       

      If I remove the filter the visualization is almost instanteous (< 1 sec).

       

      Add a TopN filter and the visualization takes over 30 seconds to render.

       

      The data in the bar chart is sorted the same way as the TopN would need it, so I don't think it's a sort issue.