cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Super User II
Super User II

Matrix formatting

Hello! 

I'm having issues with formatting a matrix to a specific way. 

I want to keep the aggregated value on the title row but have the underlying row value be blank.

image.pngFrom thisimage.pngTo this

___________________________________________

image.pngExample dataset
Is this possible to accomplish?

1 ACCEPTED SOLUTION

Accepted Solutions
Super User II
Super User II

Re: Matrix formatting

Well as displaying the underlying value is the aim, drilling up is not really an option.

I managed to find something quite close to a solution, 

image.pngI changed the rowname from blank to "-" and added another row which is lacking value.
Then a measure:

Value_ = If(SELECTEDVALUE(Table1[Rowname])="-";"";SUM(Table1[Value]))


You get this:
image.png
I would like to replace the "-" with a blankspace, but there doesnt seem to be any way to make selectedvalue() consider " " a string value instead of BLANK(). 

If you know any workaround that would be great, otherwise I thank you for the help! 

View solution in original post

2 REPLIES 2
Community Support Team
Community Support Team

Re: Matrix formatting

@tex628,

 

I'm afraid this can't be achieved directly in power bi. As a workaround, you can click drill up on the left-top hand of the matrix visual.

Capture.PNG 

 

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Super User II
Super User II

Re: Matrix formatting

Well as displaying the underlying value is the aim, drilling up is not really an option.

I managed to find something quite close to a solution, 

image.pngI changed the rowname from blank to "-" and added another row which is lacking value.
Then a measure:

Value_ = If(SELECTEDVALUE(Table1[Rowname])="-";"";SUM(Table1[Value]))


You get this:
image.png
I would like to replace the "-" with a blankspace, but there doesnt seem to be any way to make selectedvalue() consider " " a string value instead of BLANK(). 

If you know any workaround that would be great, otherwise I thank you for the help! 

View solution in original post

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

January 2020 Community Highlights

January 2020 Community Highlights

Make sure you didn't miss any of the things that happened in the community in January!

Top Solution Authors
Top Kudoed Authors