Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
passants
Frequent Visitor

Always include row in a matrix visual, regardless of filter?

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?

3 REPLIES 3
PaulDBrown
Community Champion
Community Champion

@passants 

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]





Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

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.

@passants 

It refers to whatever calculation you wish to display in the matrix (you mention universities numbers)





Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.






Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors