Filter Top N rows to keep visual from breaking

sophietje1p — Thu, 23 Nov 2023 15:11:54 GMT

Hi all,

I have a table visual with over 1 million rows (1 trillion), which gives an error untill a dashboard user uses filters to reduce the number of rows to somewhere below 1 million. Using conditional formatting, I have made the visual transparant when: countdistinct(unique row id) > 150.000, aka when the visual would exceed 150.000 rows.

Ideally, the visual would be invisible untill a user filters below 150.000 rows, and then appear. However, now the visual breaks when it exceeds 1 million rows, creating the well-known grey square, which is not what I want in my dashboard.

So far I've tried using the Top N filter in the filter pane (top 150.000 unique row id), but this works extremely slow and is therefore not feasible. However, a function like this would be exactly what I'm looking for. I'm working with DirectQuery so I can't create a calculated table with the top 150.000 / 1 million rows.

Are there other ways to reduce the data in my visual so that it doesn't break anymore?

Thanks a lot!

Sophie

Re: Filter Top N rows to keep visual from breaking

lbendlin — Sat, 25 Nov 2023 02:55:59 GMT

Challenge your business users about the usefulness of that table visual. No user will ever scroll past the first 100 rows.

Aggregate your data in a meaningful way.

topic Filter Top N rows to keep visual from breaking in Custom Visuals Development Discussion

Filter Top N rows to keep visual from breaking

Re: Filter Top N rows to keep visual from breaking