Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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-...