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

[SRJPBI]

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.)

[Anonymous · Accepted solution]

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.