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 datasetIs this possible to accomplish?
Go to 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!
View solution in original post
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.
Join us in the third Triple A event!
It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.
Make sure you didn't miss any of the things that happened in the community in January!