Banding/Grouping with Direct Query/Live Connection

[Anonymous]

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 think to do this is by writing a measure - and I have done this and it works for a table but if I want to use it in a visual like a bar chart I cannot place it on the "X" axis.

Any guidance would be appreciated!  

[v-juanli-msft]

Hi @Anonymous 

How do you create this measure?

Could you share some example data?

Best Regards
Maggie

[Anonymous]

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 · Accepted solution]

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.