•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
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]
Want to read more?
Check out the full article on the original site
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