Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Problem with Grouping Data function

Dear Community,    I am facing a problem when I try to select bars on a chart to combine them as one group. I click CTRL + Right Click, but when options appear; the Group function is in gray( not a...
Need Help
Show and Tell
  • v-xicai's avatar
    v-xicai
    7 years ago

    Hi Anonymous ,

     

    To use grouping, select two or more elements on a visual by using Ctrl+click to multi-select elements. Then, right-click one of the multi-select elements and select Group from the menu that appears. You can refer to the document: https://docs.microsoft.com/en-us/power-bi/desktop-grouping-and-binning.

     

    If you need to create a measure to get total sales for per region, you can use DAX below.

     

    Total sales per region=CALCULATE(SUM(Data[sale]),FILTER(ALLSELECTED(Data),Data[Region]=MAX(Data[Region])))

    Best Regards,

    Amy

     

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

v-xicai's avatar
v-xicai
Community Support
7 years ago

Hi Anonymous ,

 

To use grouping, select two or more elements on a visual by using Ctrl+click to multi-select elements. Then, right-click one of the multi-select elements and select Group from the menu that appears. You can refer to the document: https://docs.microsoft.com/en-us/power-bi/desktop-grouping-and-binning.

 

If you need to create a measure to get total sales for per region, you can use DAX below.

 

Total sales per region=CALCULATE(SUM(Data[sale]),FILTER(ALLSELECTED(Data),Data[Region]=MAX(Data[Region])))

Best Regards,

Amy

 

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