cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
CamFi
Frequent Visitor

Hide last row data in matrix

Hi - i have a matrix with 3 drilldown rows Customer, agreement and project. 

my budgethours do not go down to project niveau, which i only wish to show them on customer and agreement level. but in my matrix it just give me duplicate vaules (as expected since it cannot find a relationship)

 

CamFi_0-1649067691434.png

 

is there a way for me to just make sure it does not show any data for the last rowlevel on this specific column? thanks 🙂

1 ACCEPTED SOLUTION
Anonymous
Not applicable

1 REPLY 1
Anonymous
Not applicable

@CamFi 

Please follow the following blog to solve your problem:

https://www.inkeysolutions.com/blogs/power-bi-use-of-isinscope/

Helpful resources

Announcements
May 2023 update

Power BI May 2023 Update

Find out more about the May 2023 update.

Submit your Data Story

Data Stories Gallery

Share your Data Story with the Community in the Data Stories Gallery.

Top Solution Authors