Duplicated Y axis values displayed as 1 term

[Anonymous]

Im having an issue where duplicate data with seperate values in the same time frame is showing up as a combined data point with horiztonal bar graph.  I would like them to be individual data points or if able to average the values of the duplicate keywords.  This is one of many examples.  visual is % by Keyword and Time.  The Duplicate keywords are being shown together as one vs individual.  When I received the data dump from Google Ads it did not include syntax so multiple keywords are being duplicated and the valued are summed to show values greater than 100% as seen below.

[v-jingzhang · Accepted solution]

Hi @Anonymous 

Here are two methods to average the values of the duplicate keywords.

One is to group by Keyword and Quarter in Power Query Editor and perform Average operation on "% of impressions" column. 

You will get below result without duplicate keywords. Use it in the bar chart. 

The other method is to change aggregation type into Average rather than Sum when you create the bar chart. Just like below. 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

[Anonymous]

@v-jingzhang The first method worked perfect.  Thank you for your help.

[Anonymous]

@amitchandak How do I do the reverse Square Y Sign.  Now that I have created the index column how do graph the data with the use of the index to individually identify each keyword?

[Anonymous]

@amitchandak Thank you

[amitchandak]

@Anonymous , Add index column to your data and then add that axis in visual and expand that axis (using the reverse square Y sign)

https://stackoverflow.com/questions/45715963/creating-an-index-column-for-power-bi