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.
Hello everybody,
I am farely new to PBI and am trying to solve a problem for some days now. I can't imagine anymore what i haven't tried, measures, (DAX) and (M) formulas, distinctcount, duplicate tables, reference tables, but nothing seems to work and i can't find a solution.
I have a table with numerous colums. De table is being updated regularly and the number of rows are growing.
The table consists of a questionary with only 4 possible answers. However the questionary itself has around 25 question.
What i need to get is this:
The date field is only for filtering.
Can anybody help me do this?
Thanx in advance!
Solved! Go to Solution.
Hi @Presti73 ,
You could try to transform data structure, choose Q1~Q5 columns, then click "unpivot column" in Edit Queries, and use this in Matrix, you will get result you want. You could refer to my sample for details.
Best Regards,
Zoe Zhi
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Presti73 ,
You could try to transform data structure, choose Q1~Q5 columns, then click "unpivot column" in Edit Queries, and use this in Matrix, you will get result you want. You could refer to my sample for details.
Best Regards,
Zoe Zhi
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you both for your solution!
The unpivoted columns did the trick. Keeping columns in on wich filters could be based, made it very versatile and usable on all visuals.
Seems like you need a multi-column aggregation: https://community.powerbi.com/t5/Quick-Measures-Gallery/Multi-Column-Aggregations-MC-Aggregations/m-...
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.