For creating Stacked Column Chart into PBI, I use the below steps :
1. Go to Power Query
2. Create a duplicate column of the field for which I need to update the graph
3. Rename the column to required name
4. Lastly I unpivot the duplicated columns and load the report
I have attached excel for your reference, which shows the table and chart been updated. (currently not able to see upload option)
There are around 6 stacked chart that I need to update to PBI Dashboard.
So for every 6 stacked charts, I again go to PBI and select get data option. So I have 6 data in Fields pane into PBI.
Is there a way a exclude the above steps that I mentioned. I do not want to create duplicate columns by going into Edit Queries.
Sorry. I'm totally new to Power BI, so going through multiple queries.