Line Chart and Dynamic Table Column

[kobebyte]

I have the fund table below which stores capitals, liability and fund on daily basis for each fund (Fund #1 and Fund #2).

I would like to display it in a line chart by transaction date with a slicer to choose whether it is from Fund#1 or Fund#2 which the slicer works fine. However, when selecting both funds in the slicer, it sums both funds. Is there a way that I could display the funds in different line in the same line chart for comparison?

I know one solution is to create a new table with each fund as a column. However, the issue is that the number of funds is dynamic. Thus, how could I create a new column based on the dynamic number of funds?

Thanks,

Byte

[v-chuncz-msft · Accepted solution]

@kobebyte,

It seems that you just need to drag FundName to Legend.

[kobebyte]

@v-chuncz-msft Thanks a lot. 

[v-chuncz-msft]

@kobebyte,

Please help mark it as answer. That way, other community members may also benefit. Your contribution is highly appreciated.