Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

PowerBi Slicer and Matrix Visualisation Issue

Hello I have a problem, where I create a Slicer(Attribute) and select multiple items to display into the Matrix table it shows me blank spaces which I do not want to see as I only want to see the the...
  • v-xuding-msft's avatar
    v-xuding-msft
    5 years ago

    Hi Anonymous ,

     

    You need to drag the measure(Subject with AND-Only Condition) into filter pane and choose "is not blank" then apply filter.

     

    Hope this can help you.

     

     

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Hi i tried the measure code and it does not seem to work do you know how i can resolve this issue?
 
 
v-xuding-msft's avatar
v-xuding-msft
Community Support
5 years ago

Hi Anonymous ,

 

We need to create a relationship between the two tables while using RELATED function. 

 

And based on the error message, there is an extra ")" in your formula. Please remove one to try again.

 

I have attached my sample above. You could download it to have a try.