cancel
Showing results for 
Search instead for 
Did you mean: 
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

View solution in original post

ubilger
Regular Visitor

Hi there. Can you by chance elaborate? 

po
Post Prodigy
Post Prodigy

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
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.