Forum Discussion
Combine and sort two unpivot graphs
Sorry for misunderstood,
So when you say, "With the first table I made a graph with categories" May I ask, what is the measure you used on a graph with categories?
correct me if I am wrong, I guess you have used the following
on y-axis - items/attributes
legend - Categories
x-axis - is it average score?
And your second table a graph with average score is setup some thing like this on x and y-axis
if this is the case, then you can sort both the graphs by Averagescore, because both are technically looking at average score for each of your items/attributes. only thing is on your first graph , in addition your are looking at average score percentage for each category.
So technically both are same, the way you presenting is different, so you can confidentally sort both graphs by averagescore and also filter wont be an issue. both of your graphs will be sorted similarly even when you apply filters.
Here is an example, both graphs before applying filter
both has same sort after applying filter
Hope it helps, Feel free to raise your point if it is not what you are looking for. if it resolves your issue, please Mark this as a solution.
Thank you.
For the first graph i use attribute on x-as, value on legend (the 4 categories) and % count of index in y-as.
For the 2nd graph i use attribute on x-as and average of value on y-as.
- AnushaSri1 year ago
Resolver II
Hi PowerBI_JJ on your first graph with %count, add average score in tooltips, so that it gives ability to sort by averagescore.
1.
2.
Now apply the same sorting order by using average acore on your other graph, so that both will be in sync and will always sort on the basis of same measure.
Hope it helps, Feel free to raise your point if it is not what you are looking for. if it resolves your issue, please Mark this as a solution.