Forum Discussion
Simple Graph?
Hello,
I am trying to create a simple graph but PowerBI wont put each X Axis value seperatley. How can i do this? Screenshot below shows the easy approach in Excel vs what PowerBI keeps doing. I have tried putting both Country and Ice Creams as non summarised but neither helps.
Thank you
J
Hi BugmanJ ,
I think [Country] shoule be a lower level under [Index]. If [Country] above [Index] it will be the higest level and visual will group same country as before. We need to expand same country by different index. So I suggest you to try "Concatenate labels" in X axis in Format.
Firstly, we need to sort the visual by "Index Country" and then turn off "Concatenate labels".
Result is as below.
Best Regards,
Rico ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
4 Replies
BugmanJ , Power Bi always groups values, So you can not get 2 UK.
https://stackoverflow.com/questions/45715963/creating-an-index-column-for-power-bi
You can add an index column in Power Query. Use that on axis with country and Expand the axis to have both together
Hey that works, but how do i get the country labels to appear for each line? As soon as i move country up above the index column, it goes and sums them all together again
You can follow the below solution if you want
Step 1 : Create a calculated column which will break the duplicacy
Step 2 : Concate the Country column and New Calculated column
Step3 : Use that column in X AXIS
Please have a look on below screenshot
Hope this will help you..
Regards
sanalytics
If it is your solution the please like and accept it as solution
Hi BugmanJ ,
I think [Country] shoule be a lower level under [Index]. If [Country] above [Index] it will be the higest level and visual will group same country as before. We need to expand same country by different index. So I suggest you to try "Concatenate labels" in X axis in Format.
Firstly, we need to sort the visual by "Index Country" and then turn off "Concatenate labels".
Result is as below.
Best Regards,
Rico ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
