Forum Discussion

JB140's avatar
JB140
New Member
6 years ago
Solved

Grouping Data

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 a...
  • v-yingjl's avatar
    v-yingjl
    6 years ago

    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.

lkalawski's avatar
lkalawski
Resident Rockstar
6 years ago

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! 😀