Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Hi,
I hope this question will be very straightforward for someone.Will really appreciate for the response.
For example I have a table called SurveyResults where Q1, Q2 and Q3 has theme saved with score (0-9) in score column
Ref | Date | Q1 | Q2 | Q3 | Score |
1 | 05/04/2020 | Happy | 3 | ||
2 | 05/04/2020 | Sad | Unhappy | 5 | |
3 | 06/04/2020 | Happy | Excited | 8 | |
4 | 07/04/2020 | Excited | 2 | ||
5 | 06/04/2020 | Sad | 5 | ||
6 | 08/04/2020 | Happy | 8 |
Date column contains
DateId | Date |
1 | 01/04/2020 |
2 | 02/04/2020 |
3 | 03/04/2020 |
4 | 04/04/2020 |
5 | 05/04/2020 |
6 | 06/04/2020 |
7 | 07/04/2020 |
8 | 08/04/2020 |
9 | 09/04/2020 |
10 | 10/04/2020 |
I wanted to show Q1, Q2 and Q3 appended in one column rather than in three columns so I created reference table in Power Query to append three tables and then bring all three tables into one table called SurveyResultDerived as below. (Please suggest if there is a better way to dealing this). In this table Survey Q is all values from Q1, Q2 and Q3 and Question No is additional column to hold which question no it belongs to.
Ref | Date | Survey Q | Score | Question No |
1 | 05/04/2020 | Happy | 3 | Q1 |
2 | 05/04/2020 | Sad | 5 | Q1 |
3 | 06/04/2020 | 8 | Q1 | |
4 | 07/04/2020 | Excited | 2 | Q1 |
5 | 06/04/2020 | 5 | Q1 | |
6 | 08/04/2020 | Happy | 8 | Q1 |
1 | 05/04/2020 | 3 | Q2 | |
2 | 05/04/2020 | Unhappy | 5 | Q2 |
3 | 06/04/2020 | Excited | 8 | Q2 |
4 | 07/04/2020 | 2 | Q2 | |
5 | 06/04/2020 | Sad | 5 | Q2 |
6 | 08/04/2020 | 8 | Q2 | |
1 | 05/04/2020 | 3 | Q3 | |
2 | 05/04/2020 | Unhappy | 5 | Q3 |
3 | 06/04/2020 | Excited | 8 | Q3 |
4 | 07/04/2020 | 2 | Q3 | |
5 | 06/04/2020 | Sad | 5 | Q3 |
6 | 08/04/2020 | 8 | Q3 |
I was able to show wordcloud using SurveyResultDerived table as it brings all combintion from SurveyResult table and then I got total responses from SurveyResult.
As charts on dashbaord are coming from two tables so selecting one chart does not effect on other chart. How this can be handled? I created a date table in between but if I add a slicer from date table it will bring all dates combinaton from date table whereas i only want matching one.
Kindly suggest how this can be achieved?
Many thanks
Not sure I am following everything going on here.
First, for your first table, you could have just unpivoted your Q columns versus what it sounds like you did. Just select the three columns, right-click in Query Editor and choose Unpivot.
Second, it sounds like you are missing a relationship between your two tables.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
21 | |
15 | |
14 | |
11 | |
7 |
User | Count |
---|---|
25 | |
24 | |
12 | |
11 | |
10 |