Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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
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.
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.
Any other ideas?:)
@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
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.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
90 | |
82 | |
62 | |
62 | |
58 |
User | Count |
---|---|
159 | |
114 | |
100 | |
75 | |
65 |