Forum Discussion

Pravallika-gadd's avatar
Pravallika-gadd
New Member
2 years ago
Solved

Pivot table in powerbi

Hi 

Could you anyone help me on this please...

Column wise I  need to show customer, product, 2024- 01, 2024,02 ...(year and month concatenate ),fy-2024...date columns are not showing as column wise .. how can I show them as a pivot table

 

 

 

Need Help

3 Replies

  • foodd's avatar
    foodd
    Community Champion
    2 years ago

    Hello Pravallika-gadd , and thank you for sharing a question with the Community.  This reply is informational. Please follow the decorum of the Community Forum when asking a question.

    Please share your work-in-progress Power BI Desktop file (with sensitive information removed) and any source files in Excel format that fully address your issue or question in a usable format (not as a screenshot). You can upload these files to a cloud storage service such as OneDrive, Google Drive, Dropbox, or to a Github repository, and then provide the file's URL.

    https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216

    Please show the expected outcome based on the sample data you provided.

    https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523/highlight/true#M607150

    This allows members of the Forum to assess the state of the model, report layer, relationships, and any DAX applied.

     

    If your requirement is solved, please make THIS ANSWER a SOLUTION ✔️ and help other users find the solution quickly. Please hit the LIKE 👍 button if this comment helps you.  Proud to be a Super User!

    • PBIdashboards's avatar
      PBIdashboards
      Post Patron
      2 months ago

      For the customer × product × month layout, Matrix with month columns is the right approach in native Power BI. The setup: Rows = Customer + Product, Columns = Year-Month (as a date hierarchy or concatenated column), Values = your measure.

      One thing to be aware of: once published, users can't add or remove columns without you going back to Desktop. If Finance teams need to slice by different time periods themselves, that's where Flexa Tables (AppSource) adds value it lets them restructure the pivot in Power BI Service directly.