Forum Discussion
Helper IPower BI table with rows filtering a dataset
Thanks, but this doesn't solve the problem.
I have ended up creating lots of measures and then arranging them in Cards as follows:
The slicers then all work.
I just can't help thinking this a very inefficient way of getting what I want.
Hi mscantle ,
Based on the data you provided, I did the following, and you can try to see if these steps meet your requirements
Let's Start with reverse perspective:
Open power query and choose both Gender and Special Need column and click unpviot column
Close and apply and then ensure there is a relationship between two tables with Addmission Number
Create a matrix visualiztion and change the calculate to average
Use date column to create a slicer
Final output
Best regards,
Albert He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly