You receive annual sales data that must be included in Power Bl reports. From Power Query Editor, you connect to the Microsoft Excel source shown in the following exhibit. You need to create a report that meets the following requirements: * Visualizes the Sales value over a period of years and months * Adds a slicer for the month * Adds a slicer for the year
正解:
1 - Select the 2019, 2020, and 2021 columns. 2 - Select Unpivot other columns. 3 - Rename the Attribute column as Year and the Value column as Sales.