Clustered column chart not refreshing in Power BI Desktop but everything else is

[Autumn]

Hello,

I have an Excel dataset with monthly data over several years that I connected to PBI Desktop and used to create several visuals, including clustered column charts. When I update the Excel with August 2023 data and refresh in PBI Desktop, all the visuals update with the August data except for the clustered column charts. I've previously successfully refreshed all the visuals including the clustered column charts. All the cells for the August 2023 row in the Excel are filled in. 

Here's an example of a visual that did update correctly, with the last column being August 2023

And here's one of the clustered charts. The August cluster is missing 2023 data

Thanks

[Idrissshatila]

Hello @Autumn ,

Can you check first if there's some sort of a filter that is preventing august to show na dcan you show if the data of august is shown in the data view.

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin
Vote for my Community Mobile App Idea 💡

[Autumn]

Hi Idris,

I just checked and there are no filters applied.

I checked data view and the data only goes up to July 2023, which is strange because some of my visuals are showing the August 2023 data point.

[Idrissshatila · Accepted solution]

@Autumn ,

try refreshing this table and you can try going to power query anc check it from there.

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin
Vote for my Community Mobile App Idea 💡

[Autumn]

Thanks @Idrissshatila, refreshing in power query worked. Thanks very much for your help.