Reorder records in graphic on page filter

[francescjp]

Helo:

I have a bar graph in a project. I need to show the top 5 records that have the highest sum.

It works perfect with totals but when page filter is applied the same records are shown. The filter is applied to graph in values but records are not being reordered based on filter value. They remains static in same position.

I attach image. Anyone knows how to force reorder the records in graph when page filter is applied (based on result filter values)

Thanks in advance.

[francescjp]

Hello @Anonymous :

It's no possible, ok.

Thank you for your help.

[Anonymous · Accepted solution]

Hi @francescjp 

I tested your question and it turns out that you can't dynamically sort the highlighted parts.

Page level selection shows only the highlighted parts. It's not a filter.

I recommend using slicer visual.

Or enable data labels. Helps you show values.

If you have any ideas, look forward to your sharing.

Regards,

Nono Chen

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