Forum Discussion

BB's avatar
BB
Regular Visitor
9 years ago

Slicer includes values 'unknown' member

SSAS live connection Slicer includes values 'unknown' member even thought the  "unknown" member set to "hidden" at dimention  level
Need Help
BB's avatar
BB
Regular Visitor
9 years ago

Hi Xiaoxin_Sheng,

I am using Power BI to connect to AS - MD.  at the dimension level the nulls are suppressed, they don’t appear in MD browser (or when browsed in excel) but I null appears when connected to PBI - Slicers. I have tried using the slicer as other visual and applying visual filter to 'is not blank'  and then reverting back to slicer but it does not work. Thanks

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi BB.

 

I haven't find a way to remove the empty member at live connection mode,perhaps you can take a look at below thread:

SLICERS -> blank value

 

Regards,

Xiaoxin Sheng