Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 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,

 

Attached below is my code however it not working.

For your kind assistance please.

 

v-xuding-msft's avatar
v-xuding-msft
Community Support
5 years ago

Hi Anonymous ,

 

Please try this:

New Table as slicer:

Subject = VALUES('Table'[Subject])

A measure:

Subject with AND-Only Condition = 
var selectedSubject=VALUES(Subject[Subject])
var countRowsFact=
COUNTROWS(
    DISTINCT(
        SELECTCOLUMNS(
            FILTER(
                'Table',
                RELATED(Subject[Subject]) in selectedSubject
                ),
                "Subject",
                RELATED(Subject[Subject])
        )
    )
)
var countRowsSubject=COUNTROWS(selectedSubject)
return
IF(countRowsFact>=countRowsSubject,countRowsFact)

 

 

https://radacad.com/slicer-with-and-condition-in-power-bi#:~:text=The%20default%20behaviour%20of%20the,%E2%80%9D%2C%20OR%20%E2%80%9CBlue%E2%80%9D.

 

 

 

  • 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.

       

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hello im having the same issue again i tried numerous times but still unable to change "Or" condition to "And" condition so that my table does not show blank spaces. can anyone assist to provide me the measure code for to copy ?

     

     

     

     

     

     

    • v-xuding-msft's avatar
      v-xuding-msft
      Community Support
      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.