Welcome to deBUG.to Community where you can ask questions and receive answers from Microsoft MVPs and other experts in our community.
0 like 0 dislike
in Power BI by 11 11 15
I have created a report using Power BI Report Builder and I want to apply a filter on the report to show just 5 records based on specific criteria, How I can do that?

1 Answer

0 like 0 dislike
by 23 25 40
edited by
Best answer

To apply a filter on a report in SSRS / Power BI follow these steps :

Steps :

  1. Go to the header of the table and right-click > select Tablix properties.
    Apply a filter in SSRS

  2. It'll open new windows select Filters > Click on Add select Expression field that you want to using for a filter.

  3. Select TopN from Operator and enter the Value
    Top 5 in the filter in SSRS

See Also

If you don’t ask, the answer is always NO!