Dimension as legend for multi expression

[Anonymous]

I need to show the dimensions as my legend values. It is working when i am having only one expression but with more than one, the expression value is coming as legend rather than dimension values.

Sample is attached. Any help would be appreciated.

Thanks.

[vamsee]

Hello,

Try this.

[Anonymous]

Thanks Vamsee, but the given idea is not working. It is still showing the expression value in the legends.

[ravikumar_iyana]

Hi Suresh,

u can click on chartproperties---> Expressions ---> click on Expression as Legend

[el_aprendiz111]

Hi,

[Anonymous]

I need to show dimension as my legend. I am not understanding what you are saying.

[Anonymous]

I need to show dimension as my legend and not expression.

[binujose1982]

Hi Suresh,

One solution for your  requirement is to create cyclic expression group.

Expression tab-> Select both expression -> click on group.

In the chart: Use the expression cycle in the bottom left to change between both expression.

I have attached the sample file.Hope this will help you.

Regards,

Binu

[qv_testing]

I think your scenario it won't work.

1. If you have one expression, second dimension shows as legend.

2. One dimension, you have to take 2 expressions with different attributes, if you have different measures it won't work.

One dimension as Date and 2 expressions

Sum({<Name={'Name1'}>}Requested)  label as Name1

Sum({<Name={'Name2'}>}Requested) label as Name2.   these shows as legend (Name1 and Name2)

OR

otherwise create Cyclic Group, based on Date and Name dimensions.

OR

This can be possible in Scatter Chart.

Have added one more date.

LegendTest:

Load * Inline [

Date, Name, Requested, Approved

2018-01-01, Name1, 250, 150

2018-02-02, Name1, 450, 350

2018-02-02, Name2, 150, 250

2018-01-01, Name2, 50, 100               // New added

];

But this works Total based. (X and Y axis)

Thanks..