Forum Discussion

TheMayor's avatar
TheMayor
Frequent Visitor
8 years ago

Bar Chart to select Subset on two Values

Hi PowerBI experts,

 

I have been struggling with his problem for a few days trying to create a chart where I have values for 12month in a total displayed.

 

I want to be able to select different combinations of entity/suppliers to show a subset of that data against the total, similar to the picture attached. This graph was created in Excel.

 

I have 13 Excel tables , 12 of which are monthly data where the entity is the column header, and the supplier is the row header.

 

I also have one more table where the monthly data is aggregated into total values.

 

How can I achieve this problem?

 

Any help/pointers are greatly appreciated.

 

 

Need Help

2 Replies

  • v-danhe-msft's avatar
    v-danhe-msft
    Microsoft Employee
    8 years ago

    Hi TheMayor,

    From your description, I want to figure out how your monthly data aggregated into total values, can you offer me more information?  I would suggest you share your Excel file if possible. If the Excel file does contain sensitive data, please upload your report to your OneDrive and send the link to me via private message.

     

    Regards,

    Daniel He

    • TheMayor's avatar
      TheMayor
      Frequent Visitor
      8 years ago

      Hi v-danhe-msft,

       

      I sent you a private message with the Excel file. 

       

      Thank you for your help!