Forum Discussion
Graficar informacion
- 6 years ago
Let's see if this is similar to what you want to do. I made an unpivot of the table to have two columns of Item 1, 2, 3. You can view it in the Power Query Editor and you can do so by selecting the Columns in Item 1, 2, 3 and clicking "Unpivot only selected columns"
The "NA" will be difficult to show on the graphic - don't know a way to do it automatically. You can only do this in a table or matrix.
The sample file is attached below the signature.
Let's see if this is similar to what you want to do. I made an unpivot of the table to have two columns of Item 1, 2, 3. You can view it in the Power Query Editor and you can do so by selecting the Columns in Item 1, 2, 3 and clicking "Unpivot only selected columns"
The "NA" will be difficult to show on the graphic - don't know a way to do it automatically. You can only do this in a table or matrix.
The sample file is attached below the signature.
Thank you very much Allison you really helped me with the solution.
Greetings.