•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
PQuery / Data models: Dynamic table changing format when encountering null/empty values
Our take
Hello, community! I’m reaching out for your expertise regarding a challenge I'm facing with a dynamic graph linked to a query in the data model. The issue arises when the graph encounters null or empty values, causing it to reset unexpectedly. I’ve already tried adjusting the advanced graph settings, specifically the "Properties follow data points" option, but that hasn’t resolved the problem. Given that I’m working with external queries, I’m hesitant to modify the entire data structure.
Hi all, hoping the community can give me a hand.
As the title says, I have a dynamic graph that plots data from a query in the data model, but when it encounters empty or null values it resets itself.
I already tried changing advanced graph settings "Properties follow data points" to no avail. Also, since im working with external queries I do not know if I can and should modifu the whole data structure to change null/empty values (it could be more bothersome for other effects).
Hope the community can guide me on this issue!
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Tagged with
#Excel alternatives for data analysis#generative AI for data analysis#big data management in spreadsheets#conversational data analysis#real-time data collaboration#intelligent data visualization#data visualization tools#enterprise data management#big data performance#data analysis tools#data cleaning solutions#rows.com#natural language processing for spreadsheets#Excel compatibility#financial modeling with spreadsheets#Excel alternatives#dynamic graph#data model#empty values#null values