Skip to main content
Microsoft Idea

Power BI

Needs Votes

Allow Slice and Dice analytics (like Pivot) on all the model attributes directly in the Web

Vote (38) Share
Michael Shparber's profile image

Michael Shparber on 10 May 2017 04:45:38

Many times users have further questions about data, questions that are beyond the scope of a given report or set of reports.
They need the ability to Slice and Dice the data as if they were working with Pivot in Excel, but without Excel.
Please add the ability to directly analyze the data in directly in Web by slicing and dicing
Thank you

Comments (14)
Michael Shparber's profile image Profile Picture

Yanxi Li on 05 Jul 2020 23:39:52

RE: Allow Slice and Dice analytics (like Pivot) on all the model attributes directly in the Web

I need this feature as well!

Michael Shparber's profile image Profile Picture

Power BI User on 05 Jul 2020 23:16:43

RE: Allow Slice and Dice analytics (like Pivot) on all the model attributes directly in the Web

I also need this feature in SSRS too

Michael Shparber's profile image Profile Picture

drg on 05 Jul 2020 23:02:29

RE: Allow Slice and Dice analytics (like Pivot) on all the model attributes directly in the Web

Stephen Fog's comment is amazing! This solves so many issues! Thanks for sharing!

Michael Shparber's profile image Profile Picture

Stephen Fog on 05 Jul 2020 23:00:57

RE: Allow Slice and Dice analytics (like Pivot) on all the model attributes directly in the Web

'Actually, this is possible currently by doing the following:
- ask a question about the data
- you'll be presented with all available fields for slice/dice (ad hoc) reporting
- select any dimension/measure by either (a) changing the question or (b) check or uncheck from the available fields
- finally choose / change the visual (matrix for a pivot or chart etc.)