Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Banding/Grouping with Direct Query/Live Connection

I am trying to create grouping/banding in my report.  I am using a live connection to AAS so I am unable to access the query editor and the grouping functionality is disabled. The only way I can thi...
Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    7 years ago

    Hi Anonymous 

    Measures can't be added in the X axis.

    As a workaround,

    If your measure shows the value of each group, you could add "category"/"group"in the X axis, then add your measure in the Value field.

    If your measure shows different groups/categories, you could create a calcuated column.

    But since you are using SSAS live connection, it is unsupported to created a column.

    So it is wise of you to ask the AAS contact to put the measure in the data layer level of AAS.

     

    Best Regards
    Maggie

     

    Community Support Team _ Maggie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-juanli-msft's avatar
v-juanli-msft
Community Support
7 years ago

Hi Anonymous 

How do you create this measure?

Could you share some example data?

 

Best Regards
Maggie

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Thanks for the response!  I think regardless of the measure I create - it will not be able to be put on the "X" axis of a bar chart, which is the business requirement.  I have decided instead to ask the AAS contact to put the measure in the data layer level of AAS.  

  • v-juanli-msft's avatar
    v-juanli-msft
    Community Support
    7 years ago

    Hi Anonymous 

    Measures can't be added in the X axis.

    As a workaround,

    If your measure shows the value of each group, you could add "category"/"group"in the X axis, then add your measure in the Value field.

    If your measure shows different groups/categories, you could create a calcuated column.

    But since you are using SSAS live connection, it is unsupported to created a column.

    So it is wise of you to ask the AAS contact to put the measure in the data layer level of AAS.

     

    Best Regards
    Maggie

     

    Community Support Team _ Maggie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.