Forum Discussion
Pivot table (like excel) dashboard in Power BI?
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,
Microsoft Employee
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,
but what if i want to compare entries after the pivot is created?
Lets say i want to create a pivot with rows as (organisation names) and columns as 3 years and values as the sum of revenue (different people of the same organisation). Next i want to assign a status by comparing the change in revenue for each row. Pivot typically allows that by aggregating entries by organisation name and then i use a simple IF function in excel
How do i do this i power bi ? not just functionality but i need to make comparison?