Forum Discussion
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...
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
Slicers are always an OR condition, but you can create a custom measure to get the AND result you want.
See if this post can help you out: https://community.powerbi.com/t5/Desktop/Slicer-with-quot-AND-quot-logic/td-p/592018
If you need it specific to your scenario you will need to provide sample data please.
PS, I am going to move this to Desktop thread where it will get more views and help since it is not related specifically to Power Query. Cheers!
Slicers are always an OR condition, but you can create a custom measure to get the AND result you want.
See if this post can help you out: https://community.powerbi.com/t5/Desktop/Slicer-with-quot-AND-quot-logic/td-p/592018
If you need it specific to your scenario you will need to provide sample data please.
PS, I am going to move this to Desktop thread where it will get more views and help since it is not related specifically to Power Query. Cheers!
Hi,
Attached below is my code however it not working.
For your kind assistance please.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)- Hi i tried the measure code and it does not seem to work do you know how i can resolve this issue?