Forum Discussion
Get Data From Excel Pivot Table - Issue with Sum of Value Row
Hello I needed to display data as a table and a chart and had to convert the data from rows to columns to make the chart display the values correctly stacked which worked manually. However wh...
I have now tried using the transpose function in Power BI and this almost works but doesn't transpose the column names to row values so all I have is the values with no indication of what the values relate to so I cannot use this method unless there is something I am missing as this somewhat limits the usefulness of a transpose function.