Forum Discussion

JotaL's avatar
JotaL
Frequent Visitor
6 years ago
Solved

Selecting a Measure by clicking a Matrix Row

Hello

 

I have created a table where i displayed the several entities as columns and displayed all values as rows. Those are mainly measures. Now I would like to be able to select only the row (not the columns), that is, to select that particular measure, and by that to activate another visual displaying that measure. For example, we have data related to countries (countries will be the columns), we select a row from that matrix and doing so we would display bubbles of that measure in a Map.

 

I am quite a recent user of Power Bi and the only way I found out so far to achieve this is by using buttons.

 

Is there any other way?

Need Help
  • MFelix's avatar
    MFelix
    6 years ago

    Hi JotaL ,

     

    To what I can understand you have some measures presented on a bubble chart and on a matrix visualization, on that matrix you have turn on the measures on rows i this correct?

     

    Now you want to select the measure and activate the bubble chart for this you need to follow some steps to add the measures in the correct place:

    • Create a disconnected table with the name of your measures:
    Measure

    Measure1

    Measure2
    Measure3

     

    • Add the following measure to your model:
    Selected_Measure =
SWITCH (
    SELECTEDVALUE ( TABLE[MeasureName] );
    "Measure1"; [Measure1];
    "Measure2"; [Measure2];
    "Measure3"; [Measure3]
)

     

    Now use this measure on your values on the visualizations you need and the column of the table you created as rows of the matrix and as legend of the bubble chart, now select a row on the matrix should interact with the bubble chart as you need.

3 Replies

  • MFelix's avatar
    MFelix
    Super User
    6 years ago

    Hi JotaL ,

     

    To what I can understand you have some measures presented on a bubble chart and on a matrix visualization, on that matrix you have turn on the measures on rows i this correct?

     

    Now you want to select the measure and activate the bubble chart for this you need to follow some steps to add the measures in the correct place:

    • Create a disconnected table with the name of your measures:
    Measure

    Measure1

    Measure2
    Measure3

     

    • Add the following measure to your model:
    Selected_Measure =
SWITCH (
    SELECTEDVALUE ( TABLE[MeasureName] );
    "Measure1"; [Measure1];
    "Measure2"; [Measure2];
    "Measure3"; [Measure3]
)

     

    Now use this measure on your values on the visualizations you need and the column of the table you created as rows of the matrix and as legend of the bubble chart, now select a row on the matrix should interact with the bubble chart as you need.

    • JotaL's avatar
      JotaL
      Frequent Visitor
      6 years ago

      Bom dia e obrigado!

       

      In fact I had thought of something like that before, and i was using the steps described here which are quite similar to yours

      https://community.powerbi.com/t5/Desktop/Choose-between-measures-in-a-slicer/td-p/223118

       

      My only issue with this solution is that assigning the new column with measure names would as rows brings me other issues, but more on how I will configure the matrix. 

      But this is still a better solution than use different pages, one per measure, and jump through them using buttons.

       

      One of the issues I have is that I have conditional formatting for some measures, that cannot be applied to all the same way as some the high values are positive, others are negative. But I will handle it somehow. Thank you again!

      • MFelix's avatar
        MFelix
        Super User
        6 years ago

        Hi JotaL ,

         

        Regarding the conditional formatting that passes by making a switch statment for the conditional formatting and using it as your formatting option something similar to:

        Selected_Measure =
SWITCH (
    SELECTEDVALUE ( TABLE[MeasureName] )= "Measure1" && [Measure1]<0;"#FFFFFF";
    SELECTEDVALUE ( TABLE[MeasureName] )= "Measure1" && [Measure1]>0;"#000000";
    SELECTEDVALUE ( TABLE[MeasureName] )= "Measure2" && [Measure2]<0;"#789452";
    SELECTEDVALUE ( TABLE[MeasureName] )= "Measure2" && [Measure2]>0;"#111111"

)

        Don't mind the colour coding I just wrote some random number and codes.