Forum Discussion

letizia928's avatar
letizia928
Regular Visitor
3 years ago

How to avoid repetition in Matrix visualization on Power BI?

Hi everyone and thank you in advance for your answers. I have a matrix visualization in Power BI which takes data from many tables. In the rows I have employee names together with the Leave Type. In the columns I have the number of the days of each month, that can be selected from two filters (month and year). In the values field I have two measures that calculate the worked hours for each employee. What I would like to do is avoiding the situation shown in the picture below: I don't want worked hours be repeated like this (even though they're in the right column, which is W that stays for Worked). How can I work this out?

No RepliesBe the first to reply