Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
There is from my knowledge two ways to build a datamodel from a survey:
1. One Fact and then two dimensions Question and Answer
2. One Fact and each question has its own dimension to be able to set together 2 questions in the same chart as an example
Now, from time to time I get the question, if it is possible to show all the answers in a chart even if the answers is zero. Neither of the above let me do that, since using a date dimension will remove any answer outside the choosen period.
What possible ways or datamodels could I use or is it almost impossible?
Hi @Bokazoit - While traditional fact-dimension models may not directly support the display of zero answers, with the strategies outlined above, you can design a data model that allows for comprehensive reporting of all possible answers. Adjusting your data preparation, utilizing comprehensive dimensions, and crafting thoughtful measures will help you achieve the desired outcomes in your reports.
You can create DAX measures that return a default value (like zero) when there are no responses for specific combinations of questions and answers. Use the coalese() function or similar logic to ensure that zeros are shown when there are no records.
Hope the above details helps.
Proud to be a Super User! | |
Sorry I am well aware of the model building, but You give me absolutly no answers to my question. If it was that easy I would not ask but post the solution myself.
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
94 | |
87 | |
82 | |
71 | |
49 |
User | Count |
---|---|
143 | |
123 | |
107 | |
61 | |
55 |