The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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.)
Solved! Go to 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.
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.