Blank fields on slicers - dissapears after refreshing! What's going on?

[arhetyp]

Hi guys,

I am getting frustrated with blank fields on slicers. Thers are for sure NO empty data in my repoets - all numbers/indicators all OK (compared with other sources). 

What's the most frustrating it sometimes seems to be fine and then after saving and reopening fPower BI ile again the blank fields come back!:)

What is funny you have just to refresh data and the blanks disappear again. However this is not a solution - raports are submited to external users.

Has anyone encountered similiar issue and know whether thers is any 100% working solutions?

I will appreciate your answer!

Arek

[Anonymous]

The most common reason for this is missing values in your lookup table.  Like, if your fact/data table references CustomerId=777, but your Customer tables doesn't HAVE a 777, then you may get a blank in your slicers.

[arhetyp]

Yes, I am fully aware how it works - this is not a reason in this case.

As I said - there is not a problem with data.

Besides if it would be a missing values there will be no reaction after refreshing.

[arhetyp]

Any other ideas?:)

[v-yuezhe-msft]

@arhetyp,

Do you use the latest version of Power BI Desktop(2.48.4792.721)? Would you mind sharing the PBIX file so that we can test?

Regards,
Lydia Zhang

[arhetyp]

Yes, I am fully aware how it works - this is not a reason in this case.

As I said - there is not a problem with data.

Besides if it would be a missing values there will be no reaction after refreshing.