Bar Chart - Display Top N, Bottom N and everything in between on separate charts

[Anonymous]

Hi everyone, 

I need to create a bar chart comparing averages, which will be exported into a PowerPoint file. The client wants each data point displayed on a slide with 5 bar graphs per slide. When the file is published, they don’t want to filter the content; they want the slides to dynamically show the required data.

I can set up pages for the top 5 and bottom 5 data points, but I’m struggling with how to handle the data in between. Any suggestions?

[Anonymous · Accepted solution]

Hi, @Anonymous 

I've modeled some data that I hope fits your situation.

For data between Top N and Bottom N:

Measure between = 
Var _table1=CALCULATETABLE(VALUES('Table'[Product]),FILTER(ALL('Table'),[Rank asc]<=5))
Var _table2=CALCULATETABLE(VALUES('Table'[Product]),FILTER(ALL('Table'),[Rank desc]<=5))
Var _table3=UNION(_table1,_table2)
RETURN
IF(SELECTEDVALUE('Table'[Product]) in EXCEPT(VALUES('Table'[Product]),_table3),1,0)

Please see the attached document.

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Thank you so much. 

[Ritaf1983]

Hi @Anonymous 

Please provide a workable sample data and your expected result from that. It is hard to figure out what you want to achieve from the description alone.  

https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216