4 Replies Latest reply on Sep 19, 2016 8:27 AM by Lukasz Malejczyk

# Making multiple groups out of calculated measures to use them in line charts

Hello Everyone,

So I have created around 30 calculated fields in measures. first 10 are to do with revenue, next 10 to do with profit and the next 10 to do with costs. I want all three in the same chart  i.e a line chart as 3 different lines.

So, basically one line showing the trend in revenue and next line showing the movement of profit and so on. But I for the name of god cant figure out how to do it. I am still a beginner and I would like to know if there is any way to work around it.

Regards,

Dhritul

• ###### 1. Re: Making multiple groups out of calculated measures to use them in line charts

Hi Dhritul,

Is the image below responds to your needs? I wasn't sure how you would like to use those 30 measures you've created. Could you please provide bit more details?

• ###### 2. Re: Making multiple groups out of calculated measures to use them in line charts

Hello,

Thanks for the reply. So its kind of what i need. In my case the orange line would contain the first 10 measures, the blue line the next 10 measures and so on.

Is that a possibility?

• ###### 3. Re: Making multiple groups out of calculated measures to use them in line charts

If you would like to implement all of these 30 measures, I recomend to use Calculations and Parameters.

1. Create 3 parameters (per each group)

2. Create 3 calculations (per each group) with CASE statement

3. Plot each calculation on the view using Measure Values/Measure Names containers

4. Enable parameter control to filter which calculation you will present on the chart.

I'm enclosing a workbook with the solution.

Ł

• ###### 4. Re: Making multiple groups out of calculated measures to use them in line charts

Dhritul, see my last response with workbook attached.

Ł