Line Chart with more than 20 measures?

[curt1094]

Is it possible to have a Line Chart with more than 20 measures? I need to add a total of 30 measures to a line chart. If this is possible, how would I go about doing this?

[anat · Accepted solution]

there is a limitation  in line chart:

Dimensions	Measures	Result
1 dimension	1 measure	A simple line chart with a single line.
2 dimensions	1 measure	A line chart with the first dimension on the X-axis, and a line for each value of the second dimension.
1 dimension	up to 15 measures	A line chart with one line for each measure.

[Rohan]

Hi,

Though as these limitations be, We can always try to use Dummy Dimension as a loophole to tackle such scenarios. In this case, we will use 2 dimensions : Month & Dummy. in measure :

Pick(Dsort,Exp1,Exp2,Exp3,.....Exp30);

Dummy Dimension is nothing but an Unlinked Island Table with your desired Expression Labels & their Sorting Order. For your case, something like :

Dummy :

Load * Inline[

Dummy,Dsort

Exp1,1

Exp2,2

...

Exp30,30];

Try this & let me know.

Regards,

Rohan.

[anat]

Or else try to create like ad hoc report like display only those metrics based on selection