Line charts with dynamic / filterable measures

[#1]

Hello

I've been having some troubles designing a line chart with multiple measures. I recently learned that you'd add more measures to add more lines, and within that measure, add functionality that specifies the data for that specific line, like this: Sum ({<area_name={"Something">} energy)

And as the dimension is year, I can get the energy usage per year, but also per area through different lines.

However, I would like to filter what measures to view, in this case, areas. So these areas have parent areas, and I would like to know if, somehow I could filter what areas (measures) to display in my line chart.

Thanks!

[Mark_Little]

Hi,

I am not to sure what you are trying to achieve, could you possibly expand a little more or share some sample data?

Mark

[reddy-s · Accepted solution]

Hi Eddie,

I think this is what you are referring to based on the problems description.

Only the selected measures plotted.

Find the Qvf attached.

[#4]

Hello

Thanks for the reply, I tested out your application and it worked very good, I remade it so that the "Forecast" measures in this example derived from a parent value, which was very valuable. I learned a lot from your example.

Thank you!

[prananellutla]

HI sangram- for some reason multi select is not working on for me. is there anything specific  you did?

[Anonymous]

This is exactly what I've been looking for. Thanks a lot of uploading this sample. Works perfectly!