Only display top 8 bard on a bar chart

[Anonymous]

How can I display only the top bars on the bar chart? Alternatively, how can I get rid of the the scroll bar. I am trying to export via PDF, and the scroll bar is really annoying

[harshnathani]

Hi @Anonymous ,

Try Ranking the values using RANKX function.

Post that you can put a visual filter for TOP 8 values.

Regards,

Harsh Nathani

[parry2k]

@Anonymous what you mean to show only top bar and what scroll bar you are talking about? If you have too many data points on x-axis and cannot fit in the visual, you will see the scroll bar.

Share some screenshots and explain your problem.

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

[Anonymous]

I want to show the top 8-10 Bars of my stacked bar chart. The visual on my report is not very large, so there is not enough space to display all the y-values. However, I only need the top 10.

[parry2k]

@Anonymous well whatever measure you are using on value, you need to tweak that measure to control what you want to show on the bar chart.

[Anonymous]

Okay, How do I do this? 

[v-yiruan-msft · Accepted solution]

Hi @Anonymous ,

You can refer the content in the following links to achieve it:

TOP N

HOW TO FIND TOP VALUES IN POWER BI USING DAX

Show Top N and Rest in Power BI

Best Regards

Rena