Forum Discussion
Data Last Year not shown when using a filter for Locations?
Hi Power BI Forum,
I have used tremendous time on figuring out how to solve this issue. I have a Date Dim and a fact table, where I related the fact dates into date Dim. Therefore, I can filter using my date dim. I'm interresting further, to use my Location Dim, so sort out what location I wanna show based on my fact table.
The following DAX is used :
(Additonally, I also used sameperiodelastyear and tried to add ALL(Date) as other users have mentioned.
The following Picture shown here is that it works, when I have no filter on location therfore "all"
But, when I choose what of the location I end up with the following result
I tried to revoke the problem, by dragging a table out and put my location and CO2_Green_KPI into it, and the following error was displayed :
Any help will be appericated.
Regards,
David.
3 Replies
- amitchandak
Super User
Davidglol123 , You can not have bi-directional relationship with the date table. It causes Time intelligence to fail. Make it single directional
Refer
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- Davidglol123New Member
Hi Amit,
right now I have my date table single to many into my fact table. Aint that correct?
thanks!
- v-jingzhang
Community Support
Hi Davidglol123
Did you use the [CO2_Green_KPI] measure for the line? Can you show the DAX for the measure [[CO2_Per_Kg]]? In addition, you need to use the Dim Location's location column in the slicer, and create a one-to-many relationship to the location in Fact table.
Best Regards,
Community Support Team _ Jing