Forum Discussion

prichter_mk's avatar
prichter_mk
Frequent Visitor
6 years ago
Solved

Dynamic Grouping of aggregated data

Hello all,   I have a requirement to apply dynamic column grouping to aggregated data.    The underlying dataset is a table that contains STORE NUMBER, REGION, VOLUME, SALES, FORECAST.    ST...
Need Help
prichter_mk's avatar
prichter_mk
Frequent Visitor
6 years ago

v-xicai parry2k Thanks for the quick reply. I will research the use of bookmarks further, however, the actual scenario that I'm dealing with contains approximately 10 different "group by" selections, not just 2 like I provided in the example. Although possible, it's going to be difficult to create/manage/present a bookmark for each possible selection permutation. 

 

In addition, there will be multiple filtering slicers that will be selected by the user (for example, SKU #) before the data is ready to be grouped by one of the many optional column groupings. I was hoping there would be a way to dynamically choose which optional column groupings to group by via some mechanism resembling a slicer list. The user workflow does not always dictate that the same column grouping selections will be made for each filtered data set. 

  • v-xicai's avatar
    v-xicai
    Icon for Community Support rankCommunity Support
    6 years ago

    Hi prichter_mk ,

     

    It is unavailable to get some mechanism resembling a slicer list to control columns of table visual as you desired, you might post your new idea here https://ideas.powerbi.com/forums/265200-power-bi-ideas , and add your comments there to improve Power BI and make this feature coming sooner.

     

    As a workaround, you might try the bookmark or create 10 table visuals for every group.

     

    Best Regards,

    Amy

     

    Community Support Team _ Amy

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.