(Blank) value in Page Level Filter

I maintain an Employee Dashboard with several queries (Active Employee list, Resigned Employe List, Divisional Name Query, Calendar Query, etc.) connected. I observed several Report's page level filt...

Need Help

danextian
2 years ago
Hi N5

You fact table may have more distinct values in a column used in a relatoniship than in a column used in dimensioin table. In the below example, Dim doesn't have E so it will show blank instead wether in the filter pane or in a slicer.

Category (Dim) Category (Fact)

A A

B B

C C

D D

E

Forum Discussion

(Blank) value in Page Level Filter

Related content

Filter out the blank values

Measure: FILTER([value] is not blank

Help with filtering blank rows when there is a second value

Replace Values Null to Blank or Blank to Null

Filter latest Year values blank

Category (Dim)	Category (Fact)
A	A
B	B
C	C
D	D
	E