Forum Discussion
Do I need to split a row to graph unique values
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
Super UserHi 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 categories
2. 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
