TopN filter and joins

[dramus]

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

[dramus]

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]

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.

[BhaveshPatel]

Need a screenshot of the whole canvas as well.

[dramus]

[v-qiuyu-msft]

Hi @dramus,

Based on my test, if the Category and Value property fields come from different tables, and there is a relationship between those two tables. When add the TopN filter for the Category field based on Value field, the error will not throw out. Please check my attached .PBIX.

In your scenario, the error "Visual has exceeded the available resources" indicates the chart has attempted to query too much data to complete the result with the available resources. Please try filtering the visual to reduce the amount of data in the result. If issue persists, would you mind sharing the .PBIX file for our analysis?

Best Regards,
Qiuyun Yu

[BhaveshPatel]

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?