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
How would you model this data to allow for an encyclopedia-like experience using the Q&A visual? For now, the plan is to store the data in Excel, import into Power BI, and refresh it on an as-needed basis.
Desired user experience includes:
For the purpose of this forum, I've swapped out my business terms with silly examples of foods, so this challenge is easy to understand.
To be clear, there are no other data sources involved in this dataset. Meaning, this entire report is dedicated to act like an encyclopia for business terminology, definitions, related info.
Category | Subject | Definition |
Protein | Salmon | Pink fish Recommendation: eat weekly Related meals: Baked salmon |
Chicken Nuggets | Processed chicken that is fried Recommendations: eat sparingly Related meals: serve with mayo and tater tots | |
Grain | Tater Tots | Grated potatoes formed into cyclinders Recommendation: eat sparingly Related meals: serve with chicken nuggets |
Pasta | Made from semolina flour Recommendation: eat weekly Related meals: spagetti and meatballs | |
Popcorn | Fluffy snack food from corn Recommendation: great snack food Related meals: none | |
Bread | Staple food made from flour Recommendation: eat daily Related meals: sandwich | |
Fruit | Apple | Fruit from an apple tree Recommendation: eat daily to keep the doctor away Related meals: apple pancakes |
Vegetable | Broccoli | Thick stalks with green florets Recommendation: eat weekly Related meals: Beef with broccoli |
Solved! Go to Solution.
Hi @jshutters ,
Based on your descriptions, I think you could modify your question a little. If it can understand your question, the right outcome will appear. I did a test. Please check the results as follows.
You can also add definitions to make Q&A work better with your data model with "Teach Q&A" in Q&A Setup.
For more learning, please refer to the following links.
Power BI Desktop Update - October 2019 - YouTube (from 5:00)
Hope that's what you were looking for.
Best Regards,
Yuna
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @jshutters ,
Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it. Or you are still confused about it, please provide me with more details about your problem.
Best Regards,
Yuna
Hi @jshutters ,
Based on your descriptions, I think you could modify your question a little. If it can understand your question, the right outcome will appear. I did a test. Please check the results as follows.
You can also add definitions to make Q&A work better with your data model with "Teach Q&A" in Q&A Setup.
For more learning, please refer to the following links.
Power BI Desktop Update - October 2019 - YouTube (from 5:00)
Hope that's what you were looking for.
Best Regards,
Yuna
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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 |
---|---|
87 | |
87 | |
85 | |
67 | |
49 |
User | Count |
---|---|
135 | |
112 | |
100 | |
66 | |
62 |