Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Return Graph

Good morning, I have a question, In my table I get a column with years in it (a year can occures plenty of times) and 10 measures which are associated to this column, (M1,....M10). I would like to ...
Need Help
  • MFelix's avatar
    MFelix
    5 years ago

    Hi Anonymous ,

     

    If you are using measures on your values you are not abble to get the result you need simply with the use of this measures and the year column.

     

    Create a new table with all your measure names and and ID column something similar to:

    ID MeasureName
    1 Measure1
    2 Measure2
    ... ...
    10 Measure10

     

    Now create the following measure:

    Selection =
SWITCH (
    SELECTEDVALUE ( Table[MeasureName] ),
    1, [Measure1],
    2, [Measure2],
    ..., ...
    10, [Measure10]
)

     

    Now make your line chart with the following setup:

    • Axis: MeasureName (Column)
    • Legend: Year (Column)
    • Values: Selection (Measure)

    Should return expected values

MFelix's avatar
MFelix
Super User
5 years ago

Hi Anonymous ,

 

If you are using measures on your values you are not abble to get the result you need simply with the use of this measures and the year column.

 

Create a new table with all your measure names and and ID column something similar to:

ID MeasureName
1 Measure1
2 Measure2
... ...
10 Measure10

 

Now create the following measure:

Selection =
SWITCH (
    SELECTEDVALUE ( Table[MeasureName] ),
    1, [Measure1],
    2, [Measure2],
    ..., ...
    10, [Measure10]
)

 

Now make your line chart with the following setup:

  • Axis: MeasureName (Column)
  • Legend: Year (Column)
  • Values: Selection (Measure)

Should return expected values

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    MFelix Thank you, I tried it but I can't put Year in the legend because is not in the same table so they ask me to manage the relashionship between the two tables. And I can't do it because it's doesn't exist any.

    Have you have some idea?

    Thank you

    • MFelix's avatar
      MFelix
      Super User
      5 years ago

      Can you share a sample of your data model, and how the measures are calculated?