How to filter a chart on the last day of the previous month

[FredLEGUEN]

Good morning all,

I'm working on an existing Power BI report where the source is the result of a complex SQL query. The problem is not to build a real Power BI report (Power Query, measures, Data Model) but to return the same results as the previous version.

For all the tables / card and so on, no problem, the result is similar between both techniques but not for some line charts.

For instance, the old chart doesn't display the values for the current month (the blue-light line) but with my chart, I see the values for September (and that's not good)

Both chart have the same filter and the source for the 2 charts have data for September

Do you know what I should do to not represent the data of the current month in my chart?

Thnaks

[parry2k · Accepted solution]

@FredLEGUEN now I see the issue, it means you will have two relationships with the fact table and I believe there is an inactive relationship with skClearedDate, create athe  new measure using following and then use it in the visual and use date from date dimension for relative filtering

Clear Date Measure = 
CALCULATE ( 
   <<measure you want to use>>,
   USERELATIONSHIP ( FactTable[skClearDate], DateDimenstion[Date] )
)

✨ Follow us on LinkedIn and  to our YouTube channel

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make effort to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡ Visit us at https://perytus.com, your one-stop shop for Power BI-related projects/training/consultancy.

[FredLEGUEN]

That's it.

The problem was the relationship between my tables

Thanks @parry2k for your help

[parry2k]

@FredLEGUEN what do you see in the date range?

[FredLEGUEN]

@parry2k ,

The relationship between my timetable and my fact table is on the Due Date. But for this chart, the relationship should be with the skClearedDate

[parry2k]

@FredLEGUEN and also can you make sure the column on the x-axis is used from the correct table. 

✨ Follow us on LinkedIn and  to our YouTube channel

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make effort to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

[parry2k]

@FredLEGUEN what do you see the date range on the filter where you see the current month data?

✨ Follow us on LinkedIn and  to our YouTube channel

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make effort to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

[FredLEGUEN]

Hi @parry2k ,
Can you rephrase your question, I don't understand what I have to check
Otherwise my date on my X-axis is correct considering my data model