Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi, I have survey data where the survey was sent in January and June. There are 3 questions, and 5 response options:
Each page of my report is dedicated to a question. I want to include a table visual that shows the 5 responses, then the % of people that answered in each response in January, then June, and then calculate the % change.
I would then like to include filters on the page, so users can drill down.
I've attached some made up data to represent my survey data. Please can some help? I can't figure out whether I need a measure (doesn't seem to work when I try) or whether I need calculated columns, however due to the Jan/Jun split i'm not sure.
Help please!
Solved! Go to Solution.
maybe you can create measures
pls see the attachment below
Proud to be a Super User!
To give some more context....I've managed to get this:
But I did this by creating this table....
And now can't add any slicers in the report because I can't get a relationship between that table and the main table
maybe you can create measures
pls see the attachment below
Proud to be a Super User!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |