Hi @Fufu_26 ,
There is no way to automate the creation of different Bar Charts when you upload a second table to Desktop and still want to use the chart created by the fields of the first table. But you can use parameters in Power BI Desktop to do this which still need you to select the parameters manually. Here are steps.
1, In PowerBI Desktop, under the "Modeling" tab, click "New Parameter".
For example, the parameter created according to the above default value is to establish a sequence of integers from 0 to 20: 0, 1, 2, 3... 20, click OK, a slicer will appear on the canvas, because when creating a new parameter, there is a default option in the lower left corner: add a slicer to this page, you can adjust the value of the parameter by sliding the slicer.
2,After you upload the second table, you can create a measure to control the display of the chart.
SELECTEDVALUE ( Parameter[Parameter] ) = 0,
MAX ( 'Table1'[Number of users 2021] ),
SELECTEDVALUE ( Parameter[Parameter] ) = 1,
MAX ( 'Table2'[Number of users 2021] )
3, Put "App" and "Measure" into a chart.
4, Then you can get the chart you want accoding to the selected value of the slicer as below.
If you have more EXCEL files, you can add conditions in IF function.
I attach my sample below for your reference.
Community Support Team _ xiaosun
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.