Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
po
Post Prodigy
Post Prodigy

Blank rows in matrix

Hi,

 

Have a matrix which shows o.k. until I put in a measure which compares this to previous week

 

2 levels in matrix

 

region which shows it o.k without blank rows and product which shows the balnk rows when tries to compare this to previous week.

 

When have a matrix which has multiple levels in it, is it possible to only show the value at ceratin level of matrxi such that when at second part of matrix wouldn't attamept to show it and thefore avoid the bakno rwos?

 

Dimension on left and as can see lost of dimensions with blank rows when put in 

blank_rows.JPG

1 ACCEPTED SOLUTION

Thanks for reply - toggle this has no impact.

 

Had to use isfiltered saying if not isfiltered(attribute at that level in matrxi) then show the value

View solution in original post

4 REPLIES 4
Anonymous
Not applicable

@po  - See whether changing this setting will help.

Show Rows With No Data.PNG

Thanks for reply - toggle this has no impact.

 

Had to use isfiltered saying if not isfiltered(attribute at that level in matrxi) then show the value

ubilger
Frequent Visitor

Hi there. Can you by chance elaborate? 

Hi,

 

long time ago but this may help as used this to resolve.

 

https://docs.microsoft.com/en-us/dax/isfiltered-function-dax

 

Thanks

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

Top Solution Authors