CODEWITHSUNDEEP
powerbi
Anders Rune Jensen
Anders Rune Jensen

Reputation: 3806

Missing values in PowerBI slicer

I have a problem in my cube with a dimension value as a slicer or a filter. It has no and name and I want to slice on name, but some of the values are missing. It is the same problem if I use no. If I use no as a filter and use advanced filter to search for the specific no the data works, but the slicer for name is still empty. The strange thing is that I can see the no and name fine in the data area, just not in the filter or if I use a slicer.

I have the same problem in PowerBI desktop and in the online version.

Edited:

I have several facts using the same dimensions. I have found that a disabling a specific relationship from a fact one of the dimensions makes the problem disappear. The number of values in the slicer are a bit too many, but at least now it doesn't exclude some of the values I can see. The only problem is that I need the relationship. I have checked if there should be a problem with the values for the relationship such as missing or null values, all the values are there.

Upvotes: 1

Views: 3837

Answers (2)

Lalage
Lalage

Reputation: 51

My colleague found the solution for my dashboard: when you go to the options of the X axis there is a Start and End box. In my End box there was a number, which caused the last value to disappear. When I removed this number (and Auto appeared), my graph was complete again.

enter image description here

Upvotes: 1

Anders Rune Jensen
Anders Rune Jensen

Reputation: 3806

Removing and adding the problematic fact table again solved the problem.

It was quite hard to find out what was causing the problem to begin with. I went about it by first creating a minimal cube to make sure that the core data was correct. After verifying that, I opened the problematic cube and starting removing facts and dimensions until the problem disappeared.

Upvotes: 0

Related Questions