Stacked column chart

[mohsen_safi11]

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 wanna like this

Sincerely,

Mohsen

[Dhairya · Accepted solution]

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.

[Dhairya]

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_safi11]

It was a sample I build in Excel and I also I can not edit source beacuse I use sharepoint.

[Dhairya]

Select KW12 and KW13 and Click Unpivot columns from transform tab and then try to plot the visuals.

[mohsen_safi11]

It looks like this

But I didn't want this , Do you have any idea? likes excel file I show you above

[Dhairya]

Please Try keeping only Attribute column on x-axis and Values on Y-axis and fehlerbild in legends.

[mohsen_safi11]

Thanks a lot🌷

[Dhairya · Accepted solution]

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.

[mohsen_safi11 · Accepted solution]

Yes sure