Forum Discussion
Solved
Get visual filtered by a different context when clicking on a map visual value(dot)
Hi, I'm new to PBI and I have (amongst other columns) the following data of interest about homes: price coordinate_x coordinate_y postal_code 150000 53.37876129 -2.970038891 C...
Hi ctiago ,
I create a dummy file for your reference here.
Please apply below measure to the Max Value of your gauge chart.
price_max = VAR _postal = SELECTEDVALUE('Table'[postal_code]) RETURN IF( _postal <>"", CALCULATE( MAX('Table'[price]), FILTER(ALL('Table'), 'Table'[postal_code] = _postal)), MAX('Table'[price]))Best Regards,
Joyce
isjoycewang
Solution Supplier
Solution SupplierHi ctiago ,
I create a dummy file for your reference here.
Please apply below measure to the Max Value of your gauge chart.
price_max =
VAR _postal = SELECTEDVALUE('Table'[postal_code])
RETURN
IF( _postal <>"", CALCULATE( MAX('Table'[price]), FILTER(ALL('Table'), 'Table'[postal_code] = _postal)), MAX('Table'[price]))
Best Regards,
Joyce