Forum Discussion
M_Capps
3 years agoRegular Visitor
Do I need to split a row to graph unique values
Good day, I have the following table that tracks orders and the category(ies) that the items belong in: Order Number Item Number Agency County Category 1 Category 2 Category...
- 3 years ago
Hi M_Capps
To work effectively with the data in the table, it is necessary to unpivot it.
Don't worry 25K rows is a very small database for a power bi engine.The steps for unpivot on power query:
1. Select all columns except of categories2. Use the option of "unpivot other columns"
3. close and apply.
4. Create the graph:
Please consider Accepting it as the solution to help the other members find it more quickly