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

Sincerely,

Mohsen

  • 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.

8 Replies

  • Dhairya's avatar
    Dhairya
    Solution 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_safi11's avatar
      mohsen_safi11
      Frequent Visitor

      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

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