Dashboard with question, answer and link the source

Question

Hi,I am tryin to design a dashboard which is like a question and answer and then add a link against each answer with source data. Please see picture. Also, Question 6 and 9 has sub categories to answer.&nbsp;&nbsp;User updates this file weekly as per the data from different sources. (Excel, Sharepoint file, SQL).Could you please suggest an example with sample data and any design layout.&nbsp;QuestionEntry QuestionDEPTSourceLinkRef2What trends do your complaints data show you?GM Quality &amp; Governance&nbsp;&nbsp;13How many consumers have Pressure injuries?Ans: 10Current info for the Month PI&nbsp;Tab 24Have there been any medication incidents in the past 6 months where a consumer required hospitalisation or attention by a medical officer?Ans: No&nbsp;Medication incident - iCare&nbsp;Tab 35How many consumers have had falls and required medical attention in the past 3 months&nbsp;&nbsp;Major Falls data&nbsp;Tab 46Restrictive Practice·&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Environmental = ,·&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Chemical = See CNM,·&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; PRN,·&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Reg,·&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Mechanical,·&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Physical,·&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Seclusion&nbsp;Psych Register&nbsp;Tab 5 &amp; 77Aggressive Behavior SIRS behavior·&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Residents =·&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Staff = 0&nbsp;Rapid/ Icare&nbsp;Tab 69Consumers in service:·&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; PalliativeCare·&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SplNursingNeeds1.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Cognitive impairment, such as dementia2.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Sensory impairment3.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Disability4.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Culturally and linguistically diverse BG5.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Representation by the public guardian&nbsp;&nbsp;&nbsp;Tab 7Regards,Swathi&nbsp;

anonymous · Accepted Answer

Hi&nbsp;swathrddy&nbsp;,
You can follow the steps below to get it:
1. Prepare the data&nbsp;with columns for question, sub‑question (if any), answer, department, source, link, and additional columns

&nbsp;QuestionID&nbsp;
&nbsp;Entry Question&nbsp;
&nbsp;SubQuestion&nbsp;
&nbsp;Answer&nbsp;
&nbsp;DEPT&nbsp;
&nbsp;Source&nbsp;
&nbsp;Link&nbsp;
&nbsp;Ref&nbsp;

1
&nbsp;What trends do your complaints data show you?&nbsp;
&nbsp;
&nbsp;
&nbsp;GM Quality &amp; Governance&nbsp;
&nbsp;
&nbsp;
&nbsp;

2. Load the data from the source files into Power BI after well structured data in the data source side
Import Excel workbooks into Power BI Desktop - Power BI | Microsoft Learn
3.&nbsp;Use Power Query Editor for shaping and standardizing the data
Query overview in Power BI Desktop - Power BI | Microsoft Learn
Query Editor in Power BI for Data Transformation - GeeksforGeeks
4. Data modeling(create relationships)
Create and manage relationships in Power BI Desktop - Power BI | Microsoft Learn
5. Create a matrix or table visual
Add hyperlinks (URLs) to a table or matrix - Power BI | Microsoft Learn
6. Publish the report to Service
Publish from Power BI Desktop - Power BI | Microsoft Learn
7. Create dashboard
Create a Power BI dashboard from a report - Power BI | Microsoft Learn
Best Regards

Forum Discussion

Dashboard with question, answer and link the source

2 Replies

Related content

Please tell me the answer to this question

Please tell me the answer to this question

What is the correct answer for the following questions?

Answers to common questions about Fabric Data Factory

Rayfin AMA: Your top questions answered

Question	Entry Question	DEPT	Source	Link	Ref
2	What trends do your complaints data show you?	GM Quality & Governance			1
3	How many consumers have Pressure injuries?	Ans: 10	Current info for the Month PI		Tab 2
4	Have there been any medication incidents in the past 6 months where a consumer required hospitalisation or attention by a medical officer?	Ans: No	Medication incident - iCare		Tab 3
5	How many consumers have had falls and required medical attention in the past 3 months		Major Falls data		Tab 4
6	Restrictive Practice · Environmental = , · Chemical = See CNM, · PRN, · Reg, · Mechanical, · Physical, · Seclusion		Psych Register		Tab 5 & 7
7	Aggressive Behavior SIRS behavior · Residents = · Staff = 0		Rapid/ Icare		Tab 6
9	Consumers in service: · PalliativeCare · SplNursingNeeds 1. Cognitive impairment, such as dementia 2. Sensory impairment 3. Disability 4. Culturally and linguistically diverse BG 5. Representation by the public guardian				Tab 7

QuestionID	Entry Question	SubQuestion	Answer	DEPT	Source	Link	Ref
1	What trends do your complaints data show you?			GM Quality & Governance