Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
I am looking to "pin" a row on a matrix visualization so that it always stays in the visual regardless of a filter.
In my dashboard I have a matrix with particular universities and their graduation numbers. I have a Top N (10) filter applied to the matrix, and slicers on the dashboard to be able to look at the top 10 universities by different characteristics (by major, sizes, etc).
I would like to be able to always include a row in the matrix for one particular university's numbers, even if it's not in the top 10, so that I can compare that university's numbers to the top 10 others. Is that possible?
Create a new table (to use in the matrix) along the lines of:
New table =
VAR permament = { "University1" }
VAR universities =
CALCULATETABLE (
VALUES ( Table[Universities] ),
FILTER ( Table, Table[Universities] <> "University1" )
)
RETURN
UNION ( permanent, universities )
Now create a measure to compute the corresponding values:
New measure =
VAR University1Val =
CALCULATE (
[Your measure],
FILTER ( Table, Table[Universities] = "University1" )
)
RETURN
SUMX (
'New Table',
IF (
SELECTEDVALUE ( 'New Table'[Value] ) = "University1",
University1Val,
[Your measure]
)
)
Add the field from the new table to the matrix and the [new measure]
Proud to be a Super User!
Paul on Linkedin.
Thanks for your response!
What does [Your measure] refer to? I do not have any other measures beyond what I would be creating by following your solution.
It refers to whatever calculation you wish to display in the matrix (you mention universities numbers)
Proud to be a Super User!
Paul on Linkedin.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.