Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Filtering a matrix visual by measures

I am trying to filter a matrix visual by the measures within that visual. Here is what the matrix currently looks like: matrix

Each of the matrix values are individual measures. I would like to be able to filter this matrix such that only selected values show up, so for example I could select only 'Ttl Case Qty' and under each month only the values and the column for 'Ttl Case Qty' would show up, and not the values and columns for the other measures. I can't put a measure on a filter visual since Power BI does not allow it. I have tried putting this measure

MonthlyElementSelect = SWITCH(
    SELECTEDVALUE(s_MonthlyElementSelection[Index]),
    1, [Ttl Case Qty],
    2, [Gross Sales less POD's],
    3, [GP%],
    4, [Material Margin %],
    BLANK()
)

into a column in this table to try and visually create a filter as a kind of workaround (see here, second post from top; the original method just creates the measure and puts it on a waterfall, but here I'm trying to create a column with that same measure and putting that column on a filter visual) but no values are showing up in this column, so this does not appear to be the right approach. Any help would be very appreciated!

Need Help
  • v-xuding-msft's avatar
    v-xuding-msft
    7 years ago

    Hi Anonymous ,

     

    If you want to display  the values of one measure in matrix by default, it will be implemented.  I modify the formula you can reference.  However if to display the values of all the measures, I’m afraid it will not be implemented.

    Measure 2 =
    SWITCH (
        SELECTEDVALUE ( Table2[Index] ),
        1, [Ttl],
        2, [POD],
        3, [GP],
        [Ttl]
    )
    you can change the default measure of Ttl to what you want.

     

    Best Regards,

    Xue Ding 

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

     

2 Replies

  • v-xuding-msft's avatar
    v-xuding-msft
    Community Support
    7 years ago

    Hi Anonymous ,

     

    If you want to display  the values of one measure in matrix by default, it will be implemented.  I modify the formula you can reference.  However if to display the values of all the measures, I’m afraid it will not be implemented.

    Measure 2 =
    SWITCH (
        SELECTEDVALUE ( Table2[Index] ),
        1, [Ttl],
        2, [POD],
        3, [GP],
        [Ttl]
    )
    you can change the default measure of Ttl to what you want.

     

    Best Regards,

    Xue Ding 

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

     

    • v-xuding-msft's avatar
      v-xuding-msft
      Community Support
      7 years ago

      Hi Anonymous ,

      Could you tell me if your problem has been solved? If it is, kindly mark the helpful answer as a solution if you feel that makes sense. Welcome to share your own solution. More people will benefit from here.

       

      Best Regards,

      Xue

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