Yes you can give different colors for two measures with one dimension like below:
For that you need to create two calculated fields for 2 measures separately:
For below example i have created for sales and Profit:
1. Sales calculated field:
If Sum(Sales)>1000 then ">1000"
ELSEIF SUM([Sales])<1000 THEN "<1000"
If SUM(Profit)>2000 THEN ">2000"
ELSEIF SUM(Profit)<2000 THEN "<2000"
Drag Sales and Profit onto Columns.
After creating the calculated field for colors for two measures drag onto color shelf onto their respective measures.
Hope this helps.
Thanks for your answer,
i forgot to mention that i need this 2 measures in table with more measures.
when i create a table this doesn't work anymore.
there is other way?
and if the only way is with 2 att. columns how can i make totals for the table? because for one measure i need SUM and for other i need AVG.
Yes, you can able to show what aggregation it requires, right click on the particular measure and in the measure(sum), you can select whatever is needed.
but there is a way to do it in a table?
i mean for my first question.. about conditional formatting.