clustered chart duplicate X axis bug

[mahimabedi]

Clustered chart is showing a duplicate axis. It gets fixed on refeshing the report. Is this a bug?

[v-qiuyu-msft]

Hi @mahimabedi,

Based on my understanding, you are using the Line and Clustered column chart in the Power BI Service, and the X-axis labels are duplicate, right?

In your scenario, as you are running the report in service, you can click Edit report to check which field you have placed in the Share Axis property. You can drag this field into a table visual to check if the field actually contains the value like "Sep Sep". Also make sure you haven't placed two same fields in the Share Axis property like below:

If you have any question, please feel free to ask.

Best Regards,
Qiuyun Yu

[mahimabedi]

Checked both - the column does not have repeated values and the shared axis in the visualization pane has only only field.

[v-qiuyu-msft]

Hi @mahimabedi,

Would you please share more information so that we can try to reproduce the issue? What's the data source did you use? Did you create a report in desktop then publish to service? Did the issue occur when you run the report first time?

Best Regards,
Qiuyun Yu

[mahimabedi]

Data source is an SSAS cube. Report created in desktop and then published to service. We did not see this when we first published the report. It had be working fine for months.

[v-qiuyu-msft]

Hi @mahimabedi,

I'm not able to reproduce the issue. Please make sure the X-axis values are not duplicate in Power BI Desktop, then republish the report to Power BI Service to check if the chart display as the same result in desktop.

Best Regards,
Qiuyun Yu