Forum Discussion
Power BI slicer Values Issue ?
itsmebvk , seem like you have saved the slicer with some selected location. if for month year those values are applicable then you are seeing them else you are not.
If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
- itsmebvk4 years agoContinued Contributor
amitchandak Thanks for your reply.
As I mentioned before we have data for those periods.For example when select 202112 or 202201 or 202202 slicer values ahoing, but when I select 202111 location is not showing values. But When you add it to table its showing data for 202111 as well. Sorry I am unable yo share it as it was live connection.
- itsmebvk4 years agoContinued Contributor
Apologies for late reply. I have identified the issue. The issue causing because of one fact table where it has bidirectional relationship. I connected Dataset through SSMS and checked partitions and realized partitions were not processed properly. I had to do a work around to disable bidirectional and then proceeded partitions. It started working as expected.
Thanks again, as usual your inputs always helpful. It gives some light.