Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
How many expressions and dimensions can be usedin the bar chart?
Thanks,
Attitude
only two dimensions
and more than 1 expression
Hi Sunil
I have heard that we can use 3 dimensions and only one expression.
Can someone please verify the answer given?
Thanks,
Attitude
It is the same thing. A bar chart can have dimensionality=3, which you can achieve by either 2 dimensions and an array of expressions (any number of expressions), or 3 dimensions and single expression./HIC
Hi Henric
So do you mean to say that maximum of 3 dimensionality can be used in bar chart?
Thanks,
Attitude
if we use third dimension then it will not appear in chart
Hi Sunil
Yes you are correct I also think the same. But I heard someone saying that we can use 3 dimension in the bar chart. So I want some justification from those people.
Thanks,
Attitude
Yes, you can use three dimensions and one expression. See attachment. But you can argue that the bar chart gets cluttered and that you should not do it..
Hi All,
As the discussion is on Bar chart's dimension and expression limit, I am using two dimensions and more than two expressions, then my bar chart is automatically converted into stacked style which i dont want, I want to show my expressions in Bar only, can any one tell me how to do that?
Regards,
Yojas
Add a synthetic dimension (the last one):
=ValueLoop(1,2)
Then you can replace your 2 expressions with one:
=pick(ValueLoop(1,2), expression1, expression2)