You can use a Window function in the Beast Mode as they apply OVER the rows that are filtered. Just bear in mind that the Window functions are not applicable when you have selected to show table totals or subtotals.

You could still use the main table graph and adjust the bar length using HTML code in the Beast Mode. In the attached is the following formula used: CONCAT('<div style="background-color:#7940a1;',CONCAT('width:',RAND()*100,'px;'),'height:100%;margin-left:-75px;padding:30px">','</div>') Specifically, you can replace the…