Hello, in the attached image, you can see the GDP chart for European countries. Ther are two values for each country representing GDP for two different years(2019 and 2018). Can we through the *chart options* show only one column representing the average of these two columns, i.e. these two years?
I know we can do that through add a new column and calculate the average then show the new column only in the chart. But if we could do that through the chart option will give us more power to do more things.
Hi Ahmad,
As I mentioned in my reply to your comment on my YouTube channel. It looks like your data is in the wrong format. The layout of your source data shown in that screenshot is not suitable for Power BI/Power Pivot. It needs to be a Tabular Layout ( https://www.myonlinetraininghub.com/excel-tabular-data-format) . You can fix the layout with Power Query in Power BI: https://www.myonlinetraininghub.com/power-query-unpivot-scenarios Once your data is unpivoted you can create a column chart to show your profit over time and average the two years.
Mynda
I watched your video "Power Query Unpivot".Really you are amazing.
Thank you so much
