Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Syndicate_Admin
Administrator
Administrator

Womb

Good afternoon, I am asked to recreate the following table:

Captura de pantalla 2024-01-19 101704.png

This would be my table:

YearEnterpriseIndicator31/01/202028/02/202031/03/202030/04/202031/05/202030/06/202031/07/202031/08/202030/09/202031/10/202030/11/202031/12/2020Index
2022SonySales59912548503237257445690
2022SonyCosts of services506994577868860453172671
2022SonyOther61614052601793326173812
2022SonyPersonal Costs381485132861577549260873
2022SonyTransport costs4085597691537145146045684
2022SonyGross Margin303292485814448265411645
2022SonyEBITDA724990287010076883379266
2022SonyEBIT 515176335277179881414937
2022SonyEBT7463866988625894422908
2022SonyTaxes63100812560867319266689
2022SonyNet Income628770552631118015946910010
2022SonyProvisions6127398746524864854629911
2022SonyFinancial result9880703395725519399744

12

After some transformations, which in my opinion are convenient, the table in power BI would look like this:

Franix23_0-1705666061835.png

And the only decent array I manage to create in Power Bi would be this:

Franix23_1-1705666061958.png

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:

Captura de pantalla 2024-01-19 104812.png

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:

Captura de pantalla 2024-01-19 105106.png

Captura de pantalla 2024-01-19 105118.png

  

  

I hope you can answer my question.

2 REPLIES 2
Syndicate_Admin
Administrator
Administrator

audreygerred
Super User
Super User

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

 




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!





Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.