Forum Discussion
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
| Name1 | 32|23|32|20 | 39|23|42|40 |
| Name2 | 33|83|12|40 | 62|13|22|20 |
| Name3 | 52|93|52|70 |
1 Reply
- v-easonf-msftCommunity Support
Hi, Anonymous
A similar request has been raised by other user here.
https://community.powerbi.com/t5/Desktop/Remove-specific-rows-from-Matrix-table/m-p/377226
As of now, it is not supported to hide or remove some specific rows in such Matrix visual.Best Regards,
Community Support Team _ Eason