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

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
SRJPBI
Frequent Visitor

How to make only some items from a calculation group appear in a matrix?

Hi, I have a calculation group; let's call it group_1. It has five calculation items within it. I want to use the first four of these calculation items only in the 'rows' section of a matrix. Does anyone know if this can be done please?

 

My first thought was to add a filter to the matrix, and use group_1's ordinal column in the filter. However, when I have the matrix selected I cannot see the ordinal column in the data pane. I have checked the ordinal column's properties in the data model, and the option 'is hidden' is set to 'no'.

 

I can also get around this by creating a new calculation group, but that seems unnecessarily cluttered.

 

Can anyone help please?

 

(FYI, I'm using Power BI's built in calculation group functionality, not Tabular Editor. Not sure if that affects the answer.)

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Hi @SRJPBI 

You can consider to use the field paramater, then you can select the paramater in the slicer, you can refer to the following link about the slicer.

Let report readers use field parameters to change visuals (preview) - Power BI | Microsoft Learn

Fields parameters in Power BI - SQLBI

 

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

1 REPLY 1
Anonymous
Not applicable

Hi @SRJPBI 

You can consider to use the field paramater, then you can select the paramater in the slicer, you can refer to the following link about the slicer.

Let report readers use field parameters to change visuals (preview) - Power BI | Microsoft Learn

Fields parameters in Power BI - SQLBI

 

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

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

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors