Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Hierarchy slicer not loading all data when expanded

I am trying to use date hierarchy having year and month in the Dropdown slicer. It has data of 2 years and by default, we have kept it collapsed as shown in the image below,
1.PNG

When we try to expand the year 2020 first time it shows only January as shown below
2.PNG
even though there is data for months between January to May as shown below,

3.PNG

This issue is not there when I open the pbix in PowerBI Desktop. It only shows the above correct view when we close and open the dropdown again or make some other changes. I tried adding hierarchy as shown in the image below.
4.png

I also tried adding year and month in the slicer as shown in the image below,

SonaliDhotre_0-1624597872675.png

Can you please help me with this issue?

Status: New
Comments
PratikshaWagh
Frequent Visitor

I am also facing the same issue with the slicer.

dbexpress108
Regular Visitor

Hi,

 

I am also getting this same error - which has only presented itself over the past week or two. Would very much appreciate a quick turnaround from Microsoft to fix this bug as it is impacting all our client reports.

v-chuncz-msft
Community Support

@SonaliDhotre 

 

A similar issue has been reported internally, so stay tuned.

CRI 245122556

dbexpress108
Regular Visitor

This issue now appears to be fixed, @v-chuncz-msft can you please confirm a fix has been applied by Microsoft?

SonaliDhotre
Advocate I

Thanks for the update @dbexpress108 I have checked, The issue is fixed.

dbexpress108
Regular Visitor

@SonaliDhotreBrilliant! Great to confirm.