Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Good afternoon, I am asked to recreate the following table:
This would be my table:
Year | Enterprise | Indicator | 31/01/2020 | 28/02/2020 | 31/03/2020 | 30/04/2020 | 31/05/2020 | 30/06/2020 | 31/07/2020 | 31/08/2020 | 30/09/2020 | 31/10/2020 | 30/11/2020 | 31/12/2020 | Index |
2022 | Sony | Sales | 59 | 91 | 25 | 48 | 50 | 32 | 3 | 72 | 57 | 4 | 45 | 69 | 0 |
2022 | Sony | Costs of services | 50 | 69 | 9 | 45 | 77 | 86 | 88 | 60 | 45 | 31 | 72 | 67 | 1 |
2022 | Sony | Other | 61 | 61 | 40 | 52 | 60 | 1 | 79 | 33 | 26 | 17 | 38 | 1 | 2 |
2022 | Sony | Personal Costs | 38 | 14 | 85 | 13 | 28 | 61 | 57 | 75 | 49 | 26 | 0 | 87 | 3 |
2022 | Sony | Transport costs | 40 | 85 | 59 | 76 | 91 | 53 | 71 | 45 | 14 | 60 | 45 | 68 | 4 |
2022 | Sony | Gross Margin | 30 | 32 | 92 | 48 | 58 | 14 | 44 | 82 | 65 | 41 | 1 | 64 | 5 |
2022 | Sony | EBITDA | 7 | 2 | 49 | 90 | 28 | 70 | 100 | 76 | 88 | 33 | 79 | 26 | 6 |
2022 | Sony | EBIT | 51 | 51 | 7 | 63 | 35 | 27 | 71 | 79 | 88 | 14 | 14 | 93 | 7 |
2022 | Sony | EBT | 7 | 46 | 38 | 66 | 98 | 86 | 25 | 89 | 4 | 4 | 22 | 90 | 8 |
2022 | Sony | Taxes | 63 | 100 | 81 | 25 | 60 | 86 | 7 | 31 | 92 | 66 | 6 | 8 | 9 |
2022 | Sony | Net Income | 62 | 87 | 70 | 55 | 26 | 31 | 11 | 80 | 15 | 94 | 69 | 100 | 10 |
2022 | Sony | Provisions | 61 | 27 | 3 | 98 | 74 | 65 | 24 | 86 | 48 | 54 | 62 | 99 | 11 |
2022 | Sony | Financial result | 98 | 80 | 70 | 33 | 9 | 57 | 25 | 51 | 93 | 99 | 74 | 4 | 12 |
After some transformations, which in my opinion are convenient, the table in power BI would look like this:
And the only decent array I manage to create in Power Bi would be this:
But if I include the indicators in the rows section, it doesn't look the way I'd like.
I have tried to put a copy of the table and establish a relationship between the two, so that I can have a column of indicators as I have in the original table without performing any transformation, and thus in the matrix I can have the column of indicators. I'd look something like this:
But when I add the indicator values from either table, I don't get what I'm looking for. Additionally, I attach the data that indicates to me in the visualization panel, first the transformed table, and then the original table:
I hope you can answer my question.
Hello! You should be able to achieve the look you want with paginated reporting: Paginated reports in the Power BI service - Power BI | Microsoft Learn
Sample Power BI paginated reports - Power BI | Microsoft Learn
Hello! You should be able to achieve the look you want with paginated reporting: Paginated reports in the Power BI service - Power BI | Microsoft Learn
Sample Power BI paginated reports - Power BI | Microsoft Learn
Proud to be a Super User! | |
User | Count |
---|---|
90 | |
73 | |
68 | |
63 | |
55 |
User | Count |
---|---|
98 | |
89 | |
74 | |
67 | |
62 |