Matrix formatting

[tex628]

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.

From thisTo this

___________________________________________

Example dataset
Is this possible to accomplish?

[v-yuta-msft]

@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.

 

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.

[tex628 · Accepted solution]

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, 

I 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:

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!