Forum Discussion
mohsen_safi11
3 years agoFrequent Visitor
Stacked column chart
Dear Madam / Sir When I want to show my value in chart I see like this.I also change the type of every columns for ex1mple from whole number to text or sum to count but it doesn't work. I w...
- 3 years ago
Can you please mark that post of mine as accepted solution so that other users can find this solution quickly when they encounter similar problem.
- 3 years ago
Yes sure
Dhairya
3 years agoSolution Supplier
Can you share the screenshot of data that you have loaded in PBI desktop after removing sensitive information so that I can help in better way?
If the data you loaded is same as shown in screenshoy of excel than try to unpivot the column in power query editor.
- mohsen_safi113 years agoFrequent Visitor
It was a sample I build in Excel and I also I can not edit source beacuse I use sharepoint.
- Dhairya3 years agoSolution Supplier
Select KW12 and KW13 and Click Unpivot columns from transform tab and then try to plot the visuals.
- mohsen_safi113 years agoFrequent Visitor
It looks like this
But I didn't want this , Do you have any idea? likes excel file I show you above