Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Prepping for a Fabric certification exam? Join us for a live prep session with exam experts to learn how to pass the exam. Register now.

Reply
adumith
Helper I
Helper I

Salto de línea en Advance Card

Hola chicos,

 

He desarrollado esta fórmula DAX para calcular algunos indicadores de rendimiento para mis agentes de help desk.

 

Formula:

AgentCard = 
VAR xOpen = CALCULATE(COUNTROWS(zendesk), zendesk[status] = "Open")
VAR xSolved = CALCULATE(COUNTROWS(zendesk), zendesk[status] = "Solved")
VAR xOnhold = CALCULATE(COUNTROWS(zendesk), zendesk[status] = "On-hold")
VAR xScaled = CALCULATE(COUNTROWS(zendesk), zendesk[status] = "Scaled")
VAR xPending = CALCULATE(COUNTROWS(zendesk), zendesk[status] = "Pending")
VAR FRESTBMC =
    MAXX(
        SUMMARIZE(zendesk, zendesk[First resolution time brackets], "Count", COUNT(zendesk[First resolution time brackets])),
        [Count]
    )
VAR FRESTBMR =
    MAXX(
        FILTER(
            SUMMARIZE(zendesk, zendesk[First resolution time brackets], "Count", COUNT(zendesk[First resolution time brackets])),
            [Count] = FRESTBMC
        ),
        zendesk[First resolution time brackets]
    )
VAR FRTBMC =
    MAXX(
        SUMMARIZE(zendesk, zendesk[First reply time brackets], "Count", COUNT(zendesk[First reply time brackets])),
        [Count]
    )
VAR FRTBMR =
    MAXX(
        FILTER(
            SUMMARIZE(zendesk, zendesk[First reply time brackets], "Count", COUNT(zendesk[First reply time brackets])),
            [Count] = FRTBMC
        ),
        zendesk[First reply time brackets]
    )
VAR FRTBUMC =
    MAXX(
        SUMMARIZE(zendesk, zendesk[Full resolution time brackets (Unsorted)], "Count", COUNT(zendesk[Full resolution time brackets (Unsorted)])),
        [Count]
    )
VAR FRTBUMR =
    MAXX(
        FILTER(
            SUMMARIZE(zendesk, zendesk[Full resolution time brackets (Unsorted)], "Count", COUNT(zendesk[Full resolution time brackets (Unsorted)])),
            [Count] = FRTBUMC
        ),
        zendesk[Full resolution time brackets (Unsorted)]
    )
RETURN
    "Open: " & IF(xOpen > 0, xOpen, 0)  & UNICHAR(10) &
    "Solved: " & IF(xSolved > 0, xSolved, 0) & UNICHAR(13) & UNICHAR(10) &
    "On-hold: " & IF(xOnhold > 0, xOnhold, 0) & UNICHAR(13) & UNICHAR(10) &
    "Scaled: " & IF(xScaled > 0, xScaled, 0) & UNICHAR(13) & UNICHAR(10) &
    "Pending: " & IF(xPending > 0, xPending, 0) & UNICHAR(13) & UNICHAR(10) &
    "First reply time brackets: " & FRTBMR & " | " & IF(FRTBMC>0,FRTBMC,0) & UNICHAR(13) & UNICHAR(10) &
    "Full resolution time brackets: " & FRTBUMR & " | " & IF(FRTBUMC>0,FRTBUMC,0) & UNICHAR(13) & UNICHAR(10) &
    "First resolution time brackets: " & FRESTBMR & " | " & IF(FRESTBMC>0,FRESTBMC,0)

Lo he colocado en una tarjeta y funciona sin problemas pero no puedo alinear los datos a la izquierda ya que esta visualizacion no tiene esa propiedad.

 

He encontrado otra visualizacion llamada Advance Card que si me da lo que busco pero por alguna razón el salto de línea no funciona.

 

Cards.png

 

Me gustaría saber qué opinas al respecto y cómo crees que puedo resolver este reto.

 

Muchas gracias, 

 

 

1 ACCEPTED SOLUTION
Syndicate_Admin
Administrator
Administrator

@adumith,

La versión de junio de 2023 de PBI Desktop tiene una nueva tarjeta visual con la capacidad de alinear los datos a la izquierda. Es una función de vista previa, por lo que deberá habilitarla.

https://powerbi.microsoft.com/en-us/blog/power-bi-june-2023-feature-summary/#post-23927-_Toc13701546...

View solution in original post

1 REPLY 1
Syndicate_Admin
Administrator
Administrator

@adumith,

La versión de junio de 2023 de PBI Desktop tiene una nueva tarjeta visual con la capacidad de alinear los datos a la izquierda. Es una función de vista previa, por lo que deberá habilitarla.

https://powerbi.microsoft.com/en-us/blog/power-bi-june-2023-feature-summary/#post-23927-_Toc13701546...

Helpful resources

Announcements
May PBI 25 Carousel

Power BI Monthly Update - May 2025

Check out the May 2025 Power BI update to learn about new features.

Notebook Gallery Carousel1

NEW! Community Notebooks Gallery

Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.

May 2025 Monthly Update

Fabric Community Update - May 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors
Top Kudoed Authors