Top N filtering not available in Power BI

Aarti Jadhav 65 Reputation points
2024-11-11T02:44:34.61+00:00

Hello,

I am new to Power BI, I wanted to build a bar chart with TOP 3 values. But I am not able to see the Top N filter in Filters pane, only "Basic Filtering" option is available. I have attached the screen shot for the same.

TopN_not_working.png

I am plotting Facility name by Average LOS days, I need top 3 facility names based on Average LOS days value. Average LOS days is a measure.

I also tried using the LOS days column directly without using measure, and the using average from the X-axis series values, but still getting the same issue.

The second problem is I able to see only "is less than" option for Average LOS days filter in Filter pane and no other option is available.

Only_less_than.png

I have also tried re-installing Power BI but still getting the same problem.

Please help me to resolve the issue.

Thank you.

Microsoft Power Platform Training
Microsoft Power Platform Training
Microsoft Power Platform: An integrated set of Microsoft business intelligence services.Training: Instruction to develop new skills.
488 questions
0 comments No comments
{count} votes

Accepted answer
  1. Syed Saleem Peera 8,825 Reputation points Microsoft Vendor
    2024-11-11T06:05:45.31+00:00

    Hi Aarti Jadhav,

    Thank you for reaching out to us on Microsoft Q&A forum.

    We tried from our end; it's working fine for us. Kindly refer the below screenshots.

    Additionally, I recommend checking if changing the theme mode (to Dark Mode or Light Mode) resolves any visual inconsistencies, as sometimes theme settings can affect how filters appear.User's imageUser's image If you are still facing any issue, please let us know in the comments and where you are encountering this error along with the screenshot for reference. We are glad to help you.

    Please don’t forget to Accept Answer and Yes for "was this answer helpful" wherever the information provided helps you, this can be beneficial to other community members.

    Thank you.

    1 person found this answer helpful.

0 additional answers

Sort by: Most helpful

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.