Forum Discussion
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 have a graph with my 10 measure in my x axis and the value of my measure by year as my values. I join a draw to show you what I expect.
But when I try to do it it gives me this and I don't achieve to modify it:
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
6 Replies
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 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
Can you share a sample of your data model, and how the measures are calculated?