Line or Bar graph not showing correct numbers

[adityavighne]

Hi,

I have 3 measure calculated

measure 1 = count(Table1.contacts)

measure 2 = count(Table2.contacts)

measure 3 = count(Table3.contacs)

These 3 tables are in 1:* relationship with calender table at date level

want to put this data on graph where date and these 3 measures are selected. but it's not showing correct numbers.

can you help me with this.

regards,

Aditya

[v-henryk-mstf · Accepted solution]

Hi @adityavighne ,

See if the date field types in the relational model remain the same (you need to pay attention to the difference between Date and Date/Time)

Also, you can see if a similar solution works for you.

Solved: Comparison between Date and Datetime type of data - Microsoft Power BI Community

If the problem is still not resolved, please provide detailed error information and test data Looking forward to your reply.

Best Regards,
Henry

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[rodrigosan]

Hello.
Could you share a picture of your relationship

Did I solve your problem?
Please mark as solution so others can find this solution.
https://www.linkedin.com/in/rodrigosanpbi/

[adityavighne]

[rodrigosan]

From what little I've seen, the relationships are correct.
You need to see if your dates are only dates with no times.

Did I solve your problem?
Please mark as solution so others can find this solution.
https://www.linkedin.com/in/rodrigosanpbi/