Forum Discussion
kaarel
Resolver I
Resolver ISSAS live connection Slicer shows values with no data/unknown member
Hi! I'm connected to the OLAP multidimenisonal cube. Slicer shows values where there are no data in the selection list. What setting do I need to change so that only real values are shown? I don'...
Vicky_Song
Impactful Individual
Impactful Individualkaarel, there is another thread discusses the similar issue as yours, please have a check: http://community.powerbi.com/t5/Desktop/SLICERS-gt-blank-value/td-p/6726
To summarize, you can either replace no data rows with some meaningful values or exculde empty rows with Remove Empty operation: Edit Queries -> then select that column -> choose Remove Empty.
kaarelResolver I
Resolver IThanks for the suggestion, but I'm not importing data into PowerBI Desktop data model. I'm using live connection to Analysis Services Multidimensional cube. The question is about that.
Did you find some solution?