Slicer dropdawn is empty

[ysapiyev]

Hi everyone, 

I have a report with several dropdown slicers. And sometimes, dropdown list is empty.

 

This issue can be solved by refreshing report. What is source of this issue? And how it can be resolved.

Regards,

Yerkhan

[v-danhe-msft]

Hi @ysapiyev,

Based on my test, it can always work on myside:

You could check the version of Power BI Desktop(2.60.5169.4101 64-bit (July 2018)), I would suggest you test again. If issue persists, would you please share your pbix file if possible?

Regards,

Daniel He

[ysapiyev]

@v-danhe-msft

I'm using March version. I can't share pbix file, since report is live connected to SSAS. I've noticed, that list is always empty, when I click on dropown list before every visual is finished loading. However, even if I wait until they load, list can b empty. So, I can't figure source of this issue.

Regards,

Yerkhan

[v-danhe-msft]

Hi @ysapiyev,

Due to I could not reprodece your problem, I suggest you test the problem with less data, you could refer to this link:https://docs.microsoft.com/en-us/power-bi/desktop-directquery-about#live-connections

And you could also update to the latest to version to test again.

Regars,

Daniel He

[ysapiyev]

@v-danhe-msft

Issue can be resolved by clearing filter. So, I have a question regarding header of slicer. Is it possible to remove text from header? Dropdown list of slicer doesn't fit in visual size. I can resize visual, but I will have to resize all visuals in my report.

Regards,

Yerkhan