1 of 1 people found this helpful
If you are looking for the different color setting for multiple measures, it's a bit tricky.
You can refer below link.
The forthcoming version 10.2
(the Beta 2 is ready to test)
brings conditional colors for Measures.
But any way out to resolve it in the 9.3?
Unfortunately not working in my case i am using it based on Parameter timeperiod and data also is multiple.Volume and Value is different sets.
If you can go through the formula above can understand it better.
Just place MIN(0) Green Pill twice on Columns.
Use only one of your Measures on each Axis Mark shelf.
For coloring use a distinct copy (half-a-calculation only)
of your [Slide-4 Color Code] -- one for Val, another for Vol.
Hope this makes sense.
If not, please share a sample workbook.
Remove Measure Names from Columns (and Filetrs).
Optionally remove Sum(Size) from Size on each Marks shelf.
Not sure Yuri if i am correct or not if I remove the measures name how can i get 2 columns bifurcation under category.It will overlap.
I had shown my output on the initial discussion.
The two green pills on Columns make it.
Just remove Measure Names and see what happens.
I forgot asking you to place
yet another MIN(0) green pill --
but this one on Rows.
My fault, sorry.
Please find the attached
v9.3 wb as an example.
Thanks Yuri for your kindness.
But, still in my case things not working probably because I have used Calculated field(Table Calculation).
And color coding also based on Shapes.
Didn't find any Shape in your previous screens, though :-)
I understand you can not share your workbook here,
thus we could make progress by either re-building
your perceived complexity (Table Calcs, Filters & other stuff)
in my sample wb, or keep working with your screens step-by-step.