Forum Discussion

anilp's avatar
anilp
Icon for Helper I rankHelper I
8 years ago

Grouping & Sectioning in Power Bi

Hi ,

 

I have a req' where below listed are my columns

 

Product Number  Produt Name  Product type  Unit Price 

124244433432      ABN ABRODN   BANK             1,233.00

124244433432     ABN ABRODN    BANK              3324.00

124244433432                                BANK             54454.00

134332223432    CNREMMERI       EDU INST        13324.00

123334433224    RIISJNDIDUE       EDU INST         43234.00

 

 

I want to group the data by product number level with sub total at each level.

 

I tried using the  TABLE Visualization in Power BI but it's not letting me group the date 

 

and also it shows Don't summarize the field properties, I want to summarize it.

 

Can anyone help me with this asap.

 

 

 

Need Help

2 Replies

  • v-piga-msft's avatar
    v-piga-msft
    Icon for Resident Rockstar rankResident Rockstar
    8 years ago

    Hi anilp,

     

    I couldn’t understand your requirement clearly. Could you provide me your expect result, so that I can help further for you? I would appreciate it if you could provide your sample so that I can reproduce your scenario.

     

    You can upload it to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploading.)

     

    Best Regards,

    Cherry