Forum Discussion
Power bi data filter
define "results". By default Power BI will page data in as needed (the aforementioned 500 rows) or run aggregation queries to only show distinct values.
What are you trying to accomplish with your report?
By result I mean related data/rows that are present . Ex. From the slicer you select a country and then by text filter you select a city. So then it should show all the rows with that country and that particular city.
I am using a direct query report. The issue I am facing is the time it takes to load the table after selecting a slicer value.
Which is actually not needed as the user is expected to use one more text filter after that.
I came up.with 2-3 solutions but none of them are working -
1) to apply a measure such that if a textfilter is used then only display the filtered rows
2) top n -> it is taking some time to fetch and still sometime it shows exceeded visuals
3) after slicer selection visually don't let the result affect table but internally filter it out.
Is there any other approach/solution for this ? I can't seem to get anything.