How to set y-axis of data visualization to be a variable?

[niukasu]

I have a excel file contains two columns, Date  Revenue. I have done a graph with Date as x-axis and  Revenue as y-axis.

However, I have the other excel file with two columns, Date Profit, and I want to do the same graph for this file without creating this graph again.

I know how to set a new parameter to direct the data source, but how to set a new parameter to replace the Revenue with Profit or whatever it called?

[v-xjiin-msft · Accepted solution]

@niukasu

To achieve your requirement, you can refer to following steps:

1. Go to Edit Queries. Choose Merge Queries and expand the second table to make Profit and Revenue in one sample source table.

2. Unpivot the source table make Revenue and Profit as column values:

3. Create a parameter to filter Revenue and Profit:

4. Close & Apply. Then you can use parameter to filter the chart.

Thanks,
Xi Jin.