Hi.
I have a table with more than 100 columns and more than 2000 rows of survey data. The data is weighted. Weights have been computed and is part of the table.
How do I show the percentage distribution of a particular survey variable but user can switch disaggregation by different variables?
For example:
One survey variable asks for respondents perception of how they worked with their classmates (OCCGRP RESP (groups)) and I want to show the responses by different disaggregations (e.g. gender, age, marital status).
I was able to show the responses as %s for only one disaggregation- gender (see chart below). How can I use the same visual for users to switch among the different disaggregations (age, gender, marital status).
This is my DAX for computing the %s -
Helpful resources
Power BI September 2023 Update
Take a look at the September 2023 Power BI update to learn more.
Exclusive opportunity for Women!
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!
Power Platform Conference-Power BI and Fabric Sessions
Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.
