Graph with data from information table and date table does not show values correctly.

[Anonymous]

Hey all,

I'm trying to work with two slicers based on my date table (year and quarter) and graph my information. As you can see my x-axis is based on the date table and my y-values on my information table. The slicer works correct, but the output data is always the same (which is not true). What do I do wrong?

Cheers!

[Idrissshatila]

Hello,

Make sure the active relationship (the lines with no dots in from the Date in Datum to the date in Projecten).

And if it is dotted, double click on the line between them and check the box with Make this relationship active and the cardinality in one to many.

If I answered your question, please mark my post as solution, Appreciate your Kudos👍

Follow me on Linkedin

[Idrissshatila]

Hello,

Make sure there's a relationship between date from date table and date from Data table in the data Model.

Check this link for reference https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-create-and-manage-relationships

If I answered your question, please mark my post as solution, Appreciate your Kudos👍

Follow me on Linkedin

[Anonymous]

Hey @Idrissshatila, this is already the case, see screenshot: