Forum Discussion
Solved
Problem creating a specific type of table, please advice
Hi, I just started using Power Bi and im having some trouble creating a "Excel like" table: combination of text and calculated cells, where each row is represented by a different data field (see ...
Why don't you try setting the fields as columns? Despite you'll repeat the field names for different values you'll have it solved. It's quite common in databases to set even the data fields as column values, so you can have more dynamic tables.
PS: Don't pay attention to the numbers I used, please. :smileyhappy:
What I provided is how your data could be structured, no how is it going to be displayed.
Now, for visualizing the data, you can use the data field as category and calculate the numbers from your data table. You can use months, quarters or any other grouping / filtering and also different visualizations.
I see what you mean. I transformed my data a bit, and now it works. Thanks for the advice!