Forum Discussion

Gaspar89's avatar
Gaspar89
Helper 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 convenio. Los convenios suelen estar delimitados por provincias.. pero una provincia puede tener varios convenios.

 

Necesitaría mostrar en el mapa de áreas la agrupación de los 131 convenios y al filtrar que me muestre el detalle de esos CP, así podría ver que área CP no tiene firmado un convenio y ha solicitado pago. Pero Tengo varios problemas... puedo tener en la tabla CP que no existan. Me podrían ayudar a como definirlo? para filtrando por comunidad o convenio me muestre los datos?

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.

1 Reply

  • 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.