cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Aimeeclaird
Helper IV
Helper IV

Calculate the % Change in a table + filters(?)

Hi, I have survey data where the survey was sent in January and June. There are 3 questions, and 5 response options:

  1. Always
  2. Often
  3. Sometimes
  4. Rarely
  5. Never

 

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. 

 

PBI Example Data 040821.xlsx

 

Help please!

1 ACCEPTED SOLUTION

@Aimeeclaird 

maybe you can create measures

pls see the attachment below





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

2 REPLIES 2
Aimeeclaird
Helper IV
Helper IV

To give some more context....I've managed to get this:

 

Aimeeclaird_0-1628081214614.png

 

 

But I did this by creating this table....

 

Aimeeclaird_1-1628081243477.png

And now can't add any slicers in the report because I can't get a relationship between that table and the main table

@Aimeeclaird 

maybe you can create measures

pls see the attachment below





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Get Ready for Power BI Dev Camp

Microsoft named a Leader in The Forrester Wave

Microsoft received the highest score of any vendor in both the strategy and current offering categories.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Top Kudoed Authors