Removing duplicate values in axis-x in "Stacked bar chart" visualization

[Anonymous]

How is it possible to remove duplicate values from axis-x in "Stacked bar chart" visualization , I tried all the Variations and  I'm not succeeding, maybe this is a bug of app?

I attached screenshot:

Here the details of visualization by right clicking :

Name: Stacked bar chart

Publisher: Microsoft

Id: barChart

Source: Default visual

Documentation: https://go.microsoft.com/fwlink/?linkid=2100001

[Anonymous]

Hi @Anonymous,

I think this may relate to your source data, can you please share a pbix or some dummy data that keep raw data structure with expected results? It should help us clarify your scenario and test to troubleshoot.

How to Get Your Question Answered Quickly  

Regards,

Xiaoxin Sheng

[Anonymous]

Thanks, I attache a screenshoot: 

Whenever I open the filtering, the value "1" appears more than once, I don't know why, Do you know ? It doesn't seem to be a problem with my source code since it doesn't recognize all "1" characters as the same character. Could you suggest a solution ?

[Anonymous]

HI @Anonymous,

I can't get enough information from your snapshot, perhaps you can try to add a replace step in the power query to replace blank characters.

Replace values (Power Query) (microsoft.com)
Regards,

Xiaoxin Sheng