Forum Discussion
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 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!
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
MaggieCommunity 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.
3 Replies
Hi Anonymous
How do you create this measure?
Could you share some example data?
Best Regards
MaggieHi 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
MaggieCommunity 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.