Line Chart with Dates

[Syndicate_Admin]

Good Companions

I have a question, I'm a power bi user but I haven't been able to get my brain on this. I have a table Rut_unicos :

Ruth | High Date be | Low date be | FEcha ult trx .

What I haven't been able to do is the typical line chart that shows when selecting the rut the low date be and the last trx in the same chart always the kill date is less than the last trx . This is a little thing that appears throughout the month and these two dates are marked on the chart. Do you understand?

I hope you can help me, thank you!

[Syndicate_Admin]

Hello, good, the measurements are not accepted by the line chart friend. It doesn't let you add them as an axis. I have a calendar table.

[Sahir_Maharaj]

Hello @SantinoDoggyDog @Syndicate_Admin,

Can you please try this:

1. Drag a Line Chart visual onto your canvas. For the Axis, you can use a date field from a calendar table or one of the date fields from 'Rut_unicos' if they span the full range you're interested in.

2. For the Values, you would use a measure or an aggregation. However, since you want to display specific dates, you need to create measures that return the 'Low date be' and 'Fecha ult trx' for the selected 'Rut'. (These measures will return the dates for the selected 'Rut'. You can use CALCULATE, MAX, or MIN to get these values)

LowDateForSelectedRut = 
VAR SelectedRut = SELECTEDVALUE(Rut_unicos[Ruth])
RETURN
CALCULATE(
    MAX(Rut_unicos[Low date be]),
    Rut_unicos[Ruth] = SelectedRut
)

FechaUltTrxForSelectedRut = 
VAR SelectedRut = SELECTEDVALUE(Rut_unicos[Ruth])
RETURN
CALCULATE(
    MAX(Rut_unicos[FEcha ult trx]),
    Rut_unicos[Ruth] = SelectedRut
)

3. Add slicers to your report to allow users to select a 'Rut'. This will dynamically update the line chart to show the relevant dates.

4. To ensure that 'Low date be' is always less than 'Fecha ult trx', you might need to include a visual level filter or a measure that validates this condition.

Hope this helps! Should you require any questions or further assistance, please do not hesitate to reach out to me.