Bar chart showing only values for "Blank"

[JayDPBI]

For a simple model - Client records using CreatedDate (no blanks and formated as type "Date") as relationship to a Date Table

When I try to build a Bar Chart, it's only showing value the "(Blank)" for Fiscal Year, although I'm not finding any blank CreatedDates

Selecting (Blank) in the slicer results in this same set of bars

Clicking any of the years results in an empty chart...

Here's the data model (Budget Category is from Contracts table)

And here's a screenshot of my Contacts01 (clients) data table showing Many Clients can share the same CreatedDate

And my Values are taken from this measure:

What other info would be helpful so I can figure out what I need to change to show counts for each year?

Thanks in advance!

[parry2k]

@JayDPBI awesome, glad it worked out. If you haven't already, do subscribe to my youtube channel (link below) where you will find interesting power bi related videos. cheers!!

✨ Follow us on LinkedIn and  to our YouTube channel

Learn about conditional formatting at Microsoft Reactor

My latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts 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.

[parry2k · Accepted solution]

@JayDPBI can you go to PQ and check create date value, not in the table view what you shared. Want to make sure there is no time in it. In table view, you see what you have set up in column format .

✨ Follow us on LinkedIn and  to our YouTube channel

Learn about conditional formatting at Microsoft Reactor

My latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts 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.

[JayDPBI]

@parry2k   excellent sleuthing!

That was my problem - CreatedDate has a time stamp in PQE

Changing the Format in PQE and applying resulted in a successful build of the Bar Chart!!

Thanks for your quick help!

[parry2k]

@JayDPBI can you make sure

- relationship is on the date column in the calendar table

- the create date doesn't contain timestamp in it, check it in PQ to make sure it is pure date

- check the create dates are in calendar table. 

✨ Follow us on LinkedIn and  to our YouTube channel

Learn about conditional formatting at Microsoft Reactor

My latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts 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.

[JayDPBI]

Here's my Relationship, both just type Date:

The Date table was built in DAX

'Contacts01'[CreatedDate] sorted ascending starts with Mar 1 2016

Descending Date is Dec 7 2021

@parry2k  thanks so much for taking a look!