Forum Discussion
Need help with Measure for Matrix Table and Top 5
Have you tried sorting by the sum measure in descending order?
I would go for:
Ref =
[Sum of Total Gross Incurred] * 1000000000000 + COUNT(LossRunToExcel[Reporting Location City])I got the first example to work in main file. Thank you for all the help. I will need more time this weekend to try the more creative and visual 2nd option.
Yes, it's definitely an issue in the service. You need to sort by the city field to get the axis to respect the structure:
It actually emulates the problem we used to have in Desktop when you turned off concatenate fields: for the setting to take effect, you needed to sort the axis by the fields:
It might be worth reporting the issue on the issues forum:
Have you made sure that "concatenate labels" is turned off under the x-axis options for values in the formatting pane?
Yes I did. It's even worse if turned off. Publishing is the issue.
I did report the issue and gave several screen shots of differnces between Desktop and Publishing of Clustered Column Chart with Concatenate Off.
Here is what both look like from your Sample file when published. See how City hops in front of the Cause. How do we adjust the measure to maybe change this or can we?
Yes, it's definitely an issue in the service. You need to sort by the city field to get the axis to respect the structure:
It actually emulates the problem we used to have in Desktop when you turned off concatenate fields: for the setting to take effect, you needed to sort the axis by the fields:
It might be worth reporting the issue on the issues forum:
You are correct, I had to turn Concatenate off for the X-Axis and then sort by the Sort Measure to ge the Desktop file to look right. Unfortunately it loses that when published. I will report.
Paul, here is a screen shot of an account after publishing that has less then 5 locations. Why no line or division between Cities?
It looks like you have lost the option of not concatenating the fields (same issue as we discussed previously)
I tried stacked column chart and same bad results