I have a Primary View with a log of my inventory. How do I only show rows with a value in column โJob Nameโ
I think I would be using this expression ISNOTBLANK(Inventory[Job Name])
but I am not sure where exactly to place this. I tried UX > Views > Log > Display > Show if
But it didnโt workโฆ so I thought maybe I needed to make a โSliceโ โฆ soo I did that, but IDK how to apply it to my view โLogโ.
Solved! Go to Solution.
Expression of the form Table[Column]
return a List of ALL values in the Column, for the entire Table.
Using a Slice is the correct way to go here. Your expression is close to correct, just remove the Table name.
You select what data the view points at from the UX>View, just select your new slice instead of the base Table.
Expression of the form Table[Column]
return a List of ALL values in the Column, for the entire Table.
Using a Slice is the correct way to go here. Your expression is close to correct, just remove the Table name.
You select what data the view points at from the UX>View, just select your new slice instead of the base Table.
Oh wow, I did not know after making a slice it would show up in โfor this dataโ โฆ not sure how I missed thatโฆ Thank you once again!
User | Count |
---|---|
37 | |
30 | |
29 | |
20 | |
18 |