Forum Discussion
Matrix visual filtering
Hi, In below matrix visual, how do I create slicer to get the blank values? let Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45W8srPyFPSUTI2NzNRitWB8y3MTIzB/ODEX...
Hi Anonymous ,
Please refer this measure, (Note: you need to create 0/1 table using Enter data function)
Measure 2 = var _select = SELECTEDVALUE('Table (2)'[Column1],1) var _1 = IF( [Measure]=0,BLANK(),1) var _0 = IF( [Measure]=1,BLANK(),0) return IF( _select=1,_1,_0)Best regards,
Community Support Team _ zhenbw
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
BTW, pbix as attached.
Anonymous , You have create a Measure with + 0 and filter (visual level filter) for measure =0
Measure = count(Table[Value]) +0
Create a visual level filter Measure =0
https://docs.microsoft.com/en-us/power-bi/create-reports/power-bi-report-add-filter
sorry I didnt understand, is there any example?