Forum Discussion
Dynamic Matrix based on Group of Measures
- Anonymous2 years ago
Power BI does not currently support grouping of measures by your needs, and as Ibendlin mentioned, If you would like to suggest some feature improvements, you can submit it in ideas. It is a place for customers provide feedback about Microsoft Office products.
While it is not possible to create measure groups directly, a similar effect can be achieved by calculating groupings. Please refer to the following steps to see if they help.
1. Manually create a measure selection table.
2. Use the following DAX to create a measure.
SelectedMeasure = SWITCH( TRUE(), SELECTEDVALUE(MeasureGroup[Measure]) = "Participants" && SELECTEDVALUE(MeasureGroup[Group]) = "1st Meeting", [1stMeeting_Participants], SELECTEDVALUE(MeasureGroup[Measure]) = "Duration" && SELECTEDVALUE(MeasureGroup[Group]) = "1st Meeting", [1stMeeting_Duration], SELECTEDVALUE(MeasureGroup[Measure]) = "Decisions" && SELECTEDVALUE(MeasureGroup[Group]) = "1st Meeting", [1stMeeting_Decisions], SELECTEDVALUE(MeasureGroup[Measure]) = "Participants" && SELECTEDVALUE(MeasureGroup[Group]) = "2nd Meeting", [2ndMeeting_Participants], SELECTEDVALUE(MeasureGroup[Measure]) = "Duration" && SELECTEDVALUE(MeasureGroup[Group]) = "2nd Meeting", [2ndMeeting_Duration], SELECTEDVALUE(MeasureGroup[Measure]) = "Tasks" && SELECTEDVALUE(MeasureGroup[Group]) = "2nd Meeting", [2ndMeeting_Tasks], BLANK() )3. Create a slicer and put MeasureGroup[Group] into slicer.
4. Create a Matrix visual, put DateTable[Date] into Matrix Rows, MeasureGroup[Measure] into Matrix Columns, and measure SelectedMeasure into Matrix Values.
Best Regards,
Jarvis Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
You seem to be describing the functionality of Field Parameters ?
- samblackshaw282 years ago
Helper I
I am but field parameters aren't grouped. So I would have to have all of the measures on the same slicer which I don't want. I want to be able to switch between 2 different groups of measures in the matrix.
Say I have a matrix, when the '1st Meeting' slicer option is selected, I want the matrix to show all the measures in that group, and when '2nd Meeting' slicer option do the same but for the group of 2nd meeting measures I have
- lbendlin2 years ago
Super User
If this is important to you please consider voting for an existing idea or raising a new one at https://ideas.fabric.microsoft.com
- samblackshaw282 years ago
Helper I
So it's not possible?