Dashboard with question, answer and link the source

[swathrddy]

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. 

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. 

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

Regards,

Swathi

[swathrddy]

thank you for sharing. I was wondering how do I make the answers dynamic in the table itself based on different source file. 

[Anonymous · Accepted solution]

Hi @swathrddy ,

You can follow the steps below to get it:

1. Prepare the data with columns for question, sub‑question (if any), answer, department, source, link, and additional columns

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

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. 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