On your underlying table you can pull that Color field & place it on the Rows.
This way it will always according to the sort.
Would like to show it how its done, but currently ur workbook can't be downloaded.
Can u share it here?
Hi! And thanks!
I have changed the settings on the workbook to allow download. I also saw the other email you just sent, and, that solution should work ☺
I’m going to try to replicate it now, and we’ll see how it goes. I may email you again if I can’t figure it out—hope that’s okay.
Thanks for your help.
I don’t seem to be able to replicate your mockup. You have category on color, but when I put types on color, it just changes the color of the text. If I change the mark type to “bar” from automatic, as it appears you did, I still can’t find a way to use it as a color fill—changing the size just makes the bar taller or shorter.
Could my zero values be the problem?
What do you have on “size” in your screenshot?
image003.jpg 13.0 KB
Never mind, I figured it out.
"Type" to color
SUM(Number of Records) to size
SUM(Value) to label
Shape slider moved to maximum
Text color left on automatic.
Thank you, this should work for me!
I could see ur dashboard has the color band as expected. Shall i assume that you found the solution?
By the way, after u switched to Bars just pull Number of Records (Right Click & Drag Drop) on size.
you will have this pop-up window
i always choose max(Number of Records) as this would set the full width of the cell color.
If u choose sum(Number of Records) it may create some discrepancies while interacting with filter.