Customize Sort for Tooltips Page Graph

[SMW]

Hello, 

Wondering if someone can help me. I have a cluster bar chart that I am using as a tooltip for another page. The graph shows budgets/actuals per budget category. What I would like is to be able to have the graph sort by whichever budget category has actuals that exceed the budget. 

I have tried to create a conditional measure to assess if actuals are greater than budget but have run out of options for where or how to format the visual using such conditional logic. Any help would be greatly appreciated. 

Thanks!

[Alf94]

Hi @SMW ,

I think you can try adding your conditional measure to the tooltip of your cluster bar chart (that you want to use as a tooltip). You should then be able to sort your cluster bar chart by this measure (click on the three dots on top-right of the chart --> sort axis --> your measure).

Let me know if this works. If it does not, please share sample data and screenshots so we can best help you.