Forum Discussion
data from different queries in one visual
HI Vickram,
Your age group is used text values, for the text fields, power bi will use ASCII code order to sorting. (when sorting with ASCII code, the numeric value in text type does not use general number sort orders)
Perhaps you can create a custom sort order table with all age groups and setting index for them.
Regards,
Xiaoxin Sheng
I thought I solved it by creating a separate query called "Age Group" with unqiue age group values. Then I created a relationship between Age Group Query with QueryA and QueryB. I used the Age Group column from the Query "Age Group" in the visuals instead of age group column frofm QueryA and QueryB. The result is as below:
Now, the new problem is when I used the custom sorting on the Age Group query, the issues comes back i.e. Melbourne percentage again shown as 100%. Not sure why custom sorting is causing the issue.
HI Vickram,
Your age group is used text values, for the text fields, power bi will use ASCII code order to sorting. (when sorting with ASCII code, the numeric value in text type does not use general number sort orders)
Perhaps you can create a custom sort order table with all age groups and setting index for them.
Regards,
Xiaoxin Sheng