Showing results for 
Search instead for 
Did you mean: 
Responsive Resident
Responsive Resident

Power BI slicer Values Issue ?

Hi Experts,


I am facing starange issue in my report. I created a Dataset

and published it PBI service and used it as source for other reports.


When I select certain yearmonth (202112) values in both Date and Locations slicer values are showing as shown below.




but when I select different yearmonth (202111 ) values in Location slicers are not showing as highlighted below. I have data for this yearmonth(202111) in fact table, when I add this to list values are showing but its not should in slicers.


I have join path as below, Store Dim joined on Fact Store number and Date Dim Joined with Fact on Date Dim. I am able to see data when I add to list but in slicers its not showing. 



i dont want to use bidirectional filter because of query performance. Is there anything I am missing or anything Can I do to fix this issue?  Please suggest. 

Thank you.


Super User
Super User

@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.

@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.

Responsive Resident
Responsive Resident

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.

Helpful resources

PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

MPPC 2023 PBI Carousel

Power Platform Conference-Power BI and Fabric Sessions

Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.

Top Solution Authors