Pivot Widgets in 20.108.0019 onwards
Does anyone happen to have any tip on the usage of Pivot Grid Widgets. I've tested a few to help with an extra layer of grouping for a client, but I have found few problems.
- Collapse and Expand seem to not work or slow down the widget.
- Which Collapse setting is used? Rows or Values?
- Can Filters be passed? I have a PeriodID and SubID and I can either to work.
- Is it easier to use Power BI for more complex Pivot?
Happy for any feedback or to give further information.