Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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 💡
Proud to be a Super User! | |
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 💡
Proud to be a Super User! | |
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.
@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 💡
Proud to be a Super User! | |
Thanks @Idrissshatila, refreshing in power query worked. Thanks very much for your help.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
100 | |
85 | |
77 | |
66 |
User | Count |
---|---|
120 | |
112 | |
94 | |
84 | |
75 |