Hi, I'm hoping someone can help me with a few questions I have about a single view i'd like for a dashboard. Here is what i'm trying to accomplish:
Month-over-month % difference for each measure
The ability to sort ascending/descending by each metric (via the icon that appears when you hover)
Conditional formatting by color (green for high, red for low) for the Month-over-month % difference
I know Tableau has some limitations around conditional formatting, so that' just an added bonus, if possible.
I know how to create Month-over-month calculations via this way (Month Over Month Difference As a Percentage | Tableau Software ), but i can't sort by it. I've also done so by a "Diff Last Month" calculation from another forum I saw on here, but that only gives me whole numbers difference, and not a percentage (is there a way to turn it into a percentage?).
Any and all help is extremely appreciated! Thank you!