How to create a measure that references the values of a column for a line chart?

[anoniem]

Hi everyone,

I'm working in a PBIX file that does not automatically recognizes table columns as numerical (i.e. the Sigma symbol in front of the value has disappeared, even though in the Power Query the column is decimal/numerical). I have read that this is because the PBIX file contains calculation groups.

If this was not the case, I would just be able to quickly drag the desired column/value into a visual, but this is now not possible.

To use a specific column I would have to now create a measure to use in the desired line graph. 

My problem is that I don't know which measure picks up the values as is. The Max and the Min measure only pickup the highest or the lowest value and I also can't use the Average measure.

I would like a measure that just converts a numerical column that isn't recognized as a numerical column, in order to use that as a line graph.

I would want the Period on the X-axis and the value on the Y-axis.

Could somebody help me please?

Thank you

[anoniem]

Hi both, it worked, thank you! Apparently I also had to use another column as the X-axis, which is why the measure didn't work at first

[Anonymous · Accepted solution]

Hi, @anoniem 

ray_aramburo 

You can create a Measure to do the calculation of Value as ray_aramburo says: 

Measure Value = 
SUMX('Table','Table'[Value])

Here are my test results: 

If the above one can't help you get the desired result, please provide some sample data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It is better if you can share a simplified pbix file. Thank you. 

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Fen Ling,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[ray_aramburo]

Try closing and reopening Power BI. If the issue persists then just create a simple SUM() measure on your column. Ensure as well that the column is stored as numerical column in the Model view.