How to create a new table out of multiple Measures?

[Ruslan66]

Hi everyone,

I'm pretty new to BI and ran into this problem... 

I connected BI to a VSTS project that is getting data through an Odata connector.

After i got that data in BI i created several formulas to take that data and calculate it automatically.

The problem is i have 4 measures, but when i try to put that into a visual, the graph only accepts 1 "Value" item.

when i put the 4 measures into a "table visual" it looks like this;

What i'm trying to do with this is put the 4 measures into 1 table so i could then transpose that table into 2 columns; Phases | Values. Once i'm able to achieve this i will put the "Phases" as Axis and "Values" in the Value field and get my line chart the way i want it.

I was able to achieve this by putting the data into an Excel and then importing the Excel into Power BI. But i would prefer to avoid the manual work and make BI do the work for me 😄

Plz Help

[v-xjiin-msft]

Hi @Ruslan66,

The line chart can accept multiple values. You just need to remove the Legend. But if you want to keep the Legend, then you can't put do that in current Power BI.

For the specific scenario, please share us your pbix file with One Drive or Google Drive if possible. So that we can know the actual situation and provide more proper suggestions.

Thanks,
Xi Jin.

[Ruslan66]

I must have a legend because the data collected belongs to several different projects. So Projects goes in the legend which breaks up the data into multiple lines and color codes the lines to that project's color on other charts as well. The idea of converting those measures into a table so I could flip it and create 2 columns is so I could have Axis=Phases, Legend=Projects, Values=Value

Here is an example of how I wanted it to look like and achieved this by using Excel with a bunch of formulas instead...

Now I want to achieve the same thing but without having the need for excel by pulling that data directly from the projects in VSTS and having Power BI do the calculations.

[v-xjiin-msft]

Hi @Ruslan66,

As I said above, if you want to keep the Legend in line chart. Then it is not supported to include multiple values in line chart in current Power BI. Power BI and Excel are not exactly the same.

And here's a known Idea for this feature request. You can vote it up.

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/12407130-line-chart-with-multiple...

Thanks,
Xi Jin.