Forum Discussion

mohsen_safi11's avatar
mohsen_safi11
Frequent Visitor
3 years ago
Solved

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...
General Comment
Need Help
  • Dhairya's avatar
    Dhairya
    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.

Dhairya's avatar
Dhairya
Solution Supplier
3 years ago

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's avatar
mohsen_safi11
Frequent Visitor
3 years ago

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

  • Dhairya's avatar
    Dhairya
    Solution Supplier
    3 years ago

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

    • mohsen_safi11's avatar
      mohsen_safi11
      Frequent Visitor
      3 years ago

      It looks like this

       

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

      • Dhairya's avatar
        Dhairya
        Solution Supplier
        3 years ago

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