Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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:
Solved! Go to Solution.
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:
Should return expected values
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @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:
Should return expected values
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em Português@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?
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @Anonymous ,
Has you can see I was abble to get results has expected:
Check PBIX file attach.
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsThank you!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
115 | |
99 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |