Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Remove rows with empty columns in a matrix visual

I have below matrix visual where I have classes as rows and names as subrow. In Columns I have Year and marks as subcolumns. Now it is possible that Certain name will not have marks in one year. I would like to show in my visual only those Names in the rows who has marks in all the year. I am also doing a calculation on success difference for each class for each year and it mak sense if I calculate the difference based on same number of Names in both the year.

 

Below is the matrix visual how it currently looks like in my power bi report with Year 2017 and Year 2018 as column and m1 , m2, m3,percent are subcolumn which actually are measures. There are many more rows like Class 1 and Class 2. In below example if i calculate the success of Class 1 i will like to ignore Name 3 as it is not present in year 2017. How can I achieve this ?? Thanks

 

                                                                                                                                          

               Year 2017       Year 2018

Class1    m1|m2|m3|p   m1|m2|m3|p                                                    

Name132|23|32|2039|23|42|40
Name2 33|83|12|40 62|13|22|20
Name3 52|93|52|70