Forum Discussion
Solved
Problem with pivoting table
Hello everyone, I have a table in Power BI that looks like this: Week Start Users New Amount 01/01/2024 9,994 1,459 109,365 08/01/2024 9,568 1,362 90,593 15/01/2024 10,392 1,54...
Guys, forget my question.
Enabling this option solved all my issues for now:
Anonymous Greg_Deckler
The problem is that right now this file is created manually in Excel using copy/paste.
The weeks are in columns, and the attributes are in rows. I need to replicate this format in Power BI in the same type of table.
The data from the database, of course, is in the format shown in the screenshot below.
The solution you provided is theoretically fine, but I do not have control over format in attributes, for example can't format some values into percentages %.
And since you mentioned that this approach might not be ideal, do you perhaps have another solution?