Forum Discussion

Gaspar89's avatar
Gaspar89
Icon for Helper I rankHelper I
1 year ago
Solved

Mapa Coropletico

Buenas, necesito mostrar un mapa y no se realmente como realizar el conjunto de los datos   Mi tabla de datos son apuntes por código postal de españa y estos los tengo clasificados con un número de...
Need Help
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi Gaspar89 ，

    Below is my test data.


    Create a measure to flag provinces that have not signed the agreement and have requested payment.

    Color = 
VAR aggrement = SUM('Table'[Agreement Number])
VAR RequestPayment = MAX('Table'[Request Payment])
RETURN
IF(aggrement=BLANK()&&RequestPayment="Yes","Red","Green")


    Use this measure to set the color of the bubble.


    Then on the map, the provinces that have not signed the agreement and are requesting payment are marked in a different color.


    Please see the attached pbix for reference.

    Best Regards,
    Dengliang Li

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

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi Gaspar89 ，

Below is my test data.


Create a measure to flag provinces that have not signed the agreement and have requested payment.

Color = 
VAR aggrement = SUM('Table'[Agreement Number])
VAR RequestPayment = MAX('Table'[Request Payment])
RETURN
IF(aggrement=BLANK()&&RequestPayment="Yes","Red","Green")


Use this measure to set the color of the bubble.


Then on the map, the provinces that have not signed the agreement and are requesting payment are marked in a different color.


Please see the attached pbix for reference.

Best Regards,
Dengliang Li

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