Relationship error with blank value

[Anonymous]

Hey Guys,

i want to connect these two tables to have just one slicer for each period :

When i dont connect the tables it showes me the wrong amount for the categories (see on the right bar chart)

I already have made a new table for the relationships :

When i use the new slicer with the connected tables , my Previous year data disables :

For my Previous Year data i just have made a sameperiod last year measure.

How can i fix this problem that my PY Data will still continue du show ?

[amitchandak · Accepted solution]

@Anonymous , if you are using sameperioslastyear. Make sure you are using date table. and slicer and visual are using date from date table

Why Time Intelligence Fails - Powerbi 5 Savior Steps for TI :https://youtu.be/OBf0rjpp5Hw
https://amitchandak.medium.com/power-bi-5-key-points-to-make-time-intelligence-successful-bd52912a5bd4

[Anonymous]

Hey ,

i have used the right tables for the slicers and visuals.

I have made an measure for previous year but i dont now why power bi doesnt recognize it.

When i use the normal years slicer from my sales tables it works well, but i had to make a new table with a relationship. I have 2 different tables on my page which i want to illustrate. The new Tables also worked well, the only thing that makes an issue are the Previous year number which to not appear.