Forum Discussion
Filter blank rows from table with field parameter
There are likely a few different ways to do this but I would generally approach it like this...
I would 'unpivot' your table in the Power Query editor.
Select 'NAME' column and select Transform->Unpivot Columns->Unpivot Other Columns
You should now have...
Close and Apply to return to the BI screen.
You can create a measure to return the minimum non-blank value.
Value (not Blank) =
//create a virtual table that has no blank 'values'
var _vtable =
FILTER(fruitTable, fruitTable[Value] <> "")
return
//return the minimum value from the virtual table
MINX(_vtable, fruitTable[Value])You can now build the matrix visual with Rows = [NAME], Columns = [Attribute] and Values = [Value (not blank)]
to get...
You can use the 'Attribute' column as slicer for the user to select which attributes they want displayed.
Super UserThere are likely a few different ways to do this but I would generally approach it like this...
I would 'unpivot' your table in the Power Query editor.
Select 'NAME' column and select Transform->Unpivot Columns->Unpivot Other Columns
You should now have...
Close and Apply to return to the BI screen.
You can create a measure to return the minimum non-blank value.
Value (not Blank) =
//create a virtual table that has no blank 'values'
var _vtable =
FILTER(fruitTable, fruitTable[Value] <> "")
return
//return the minimum value from the virtual table
MINX(_vtable, fruitTable[Value])
You can now build the matrix visual with Rows = [NAME], Columns = [Attribute] and Values = [Value (not blank)]
to get...
You can use the 'Attribute' column as slicer for the user to select which attributes they want displayed.
Thank you so much! This works and was easy to follow.