Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Solved! Go to Solution.
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.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |