Forum Discussion
Relationship error with blank value
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 ?
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
2 Replies
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-bd52912a5bd4Hey ,
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.