Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
3 years ago
Solved

Dynamic date range for chart

Hello everyone, I have looked for a similar topic, but I have not been able to find it. If it already exists please redirect me.

I want to create a PivotChart that affects the following 2 tables.

With the start and end dates of Vista_Sorteos I want to set the date range that filters invoice date data in Vista_ Purchases to generate a bar chart like the following:

The dates are not selected directly but an event is chosen that determines the dates:

I thank you very much for your collaboration to solve this challenge.

  • tamerj1's avatar
    tamerj1
    3 years ago

    Hi Syndicate_Admin , Anonymous 

    Please try

    Registered Clients =
VAR StartDate =
    SELECTEDVALUE ( Vista_Sorteos[fechaInicial] )
VAR EndDate =
    SELECTEDVALUE ( Vista_Sorteos[fechaFinal] )
VAR Dates =
    CALENDAR ( StartDate, EndDate )
RETURN
    CALCULATE (
        COUNT ( Vista_Compras[idCliente] ),
        TREATAS ( Dates, Vista_Compras[FechaFactura] )
    )

2 Replies