Dynamic date range for chart

[Syndicate_Admin]

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 · Accepted solution]

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] )
    )

[parry2k]

@Syndicate_Admin really tough to follow your ask here. Maybe put some sample data with the expected output. Read this post to get your answer quickly.

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490