Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
___________________________________________
Is this possible to accomplish?
Solved! 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,
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!
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.
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,
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!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
99 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
110 | |
91 | |
84 | |
66 |