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
Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi BB,

 

I can't reproduce your issue based on your description, can you share us some detail information about this issue?(e.g. screenshots, detail steps...etc)

 

Regards,

Xiaoxin Sheng

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