Forum Discussion

sanket_360's avatar
sanket_360
New Member
10 years ago
Solved

Pivot table (like excel) dashboard in Power BI?

Hi   Is there a way to create Pivot table (like excel) dashboard in Power BI? If yes, Could you please help with steps?   Regards Sanket
Need Help
  • v-sihou-msft's avatar
    v-sihou-msft
    10 years ago

    sanket_360

     

    As Greg_Deckler said, to render data like pivot table in Excel, you can use Matrix.

    If you need to add filters like pivot table, you can use slicer visual for selection to filter data.

     

    Regards, 

     

     

DavidAnthony's avatar
DavidAnthony
Icon for Helper II rankHelper II
10 months ago

Yes — there are 3 main ways:

  1. Matrix Visual (built-in)

    • Use Rows, Columns, Values — like Excel Pivot.

    • Add subtotals and drill-down for hierarchy.

  2. Field Parameters

    • Let users switch rows/columns dynamically.

    • Great for interactive dashboards.

  3. Flexa Tables (custom visual)

    • True Excel-like Pivot experience in Power BI.

    • Drag & drop fields, compare variances, manage totals easily.

    • Free on Website: Flexa Tables