Bar chart Issue - unique ID having multiple values

[kkkumar82]

Hi all,

LOAD * INLINE [

    Eid, Name, Salary

    101, KK, 1000

    101, KK, 2000

    102, PK, 3000

    103, Kis, 4000

    104, Har, 5000

];

The above is the data which I am using to create a bar chart dimension as Eid, measure Salary not sum(salary).

As you all know the bar chart will not show 101 dimension value because it doesn't know which salary to consider.

I have a strange requirement that can we show two bars for 101 Eid with 1000 and 2000 values when nothing is selected and 101 Eid is selected.

Thank You

Regards KK

[JonnyPoole · Accepted solution]

dual(Eid,Salary) as the sole dimension (calculated) will do it

[kkkumar82]

Thanks a lot Jonathan Poole,

Actually I have a similar kind of situation in my project , I will try this and let you know.

Any way thanks a lot.