Forum Discussion
Selecting a Measure by clicking a Matrix Row
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.
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.
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!
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.