Creating a line chart with a field that has different types of data

[lortizm]

I'm to create a line chart that shows for different metrics a Threshold (line 1), and a result (Line 2) for every month (x-axis). The spreadsheet is connected to a PowerApps, so different user go to the Portal to input the results for the different metrics, and then the PowerBI should show that info in the dashboard.

My problem is that when I tried creating that graph, it only shows me the option to "Count" the results (so, 1 for each month) instead of showing me the actual result in the graph to compare it to the threshold (which is also in "Count" mode).

I believe this has to do with the "type" of data. My problem is that in the column where I have the Results stored, I have different types of data (Percentage, numbers, and time in the format o mm:ss). So I don't know how to transform that data so I can show it in a graph.

Please help!

[Anonymous · Accepted solution]

Hi @lortizm ,

According to your description, here are my steps you can follow as a solution.

(1) This is my test data.  

(2) 

(3) Then the result is as follows.

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.

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly.