Grouping Data

[JB140]

Hi All,

I have values seperated by different categories ( DISC 1, DISC 2, DISC 3, CORP, ETC) within a dataset using Azure Analysis Service as a live connection to retrieve the data.

Without access to the raw data to create a calculated column, is there a way to merge "DISC 1", "DISC 2" and "DISC 3", and call that value "Saver", but still have the other catergories CORP, ETC as the same name? I am trying to use the labels in a Bar Graph so only can only use the one label.

I have tried to 'Group' the data, however because of the Live Connection, i'm not able to select the 'Group' button

Thank You in Advance!

[v-yingjl · Accepted solution]

Hi @JB140 ,

Since you cannot create a calculated column under Live Connection mode, you can create a measure named [Saver] like this and use it in the bar chart:

Saver = SUM(Sheet1[DISC1]) + SUM(Sheet1[DISC2]) + SUM(Sheet1[DISC3])

Best Regards,
Yingjie Li

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

[amitchandak]

@JB140 , binning is the way. But I doubt that will work on live connection.  So this might not be an option for live.

https://radacad.com/grouping-and-binning-step-towards-better-data-visualization
https://radacad.com/dynamic-banding-or-grouping-in-power-bi-using-dax-measures-choose-the-size-of-bi...

[lkalawski]

Hello @JB140 ,

Live connection does not allow data manipulation. All you can do is create a measure. However, a measure cannot be used as a label on a chart.
It follows that, unfortunately, it cannot be grouped in Live Connection.

All you can do is write a measure in such a way that for DISC1, the values for these three categories will be grouped and summed and will normally be calculated for the rest. However, you will not rename the tag to 'Saver'.

_______________
If I helped, please accept the solution and give congratulations! 😀