Forum Discussion
Solved
Columns with blank value
Goodday, I have a matrix with all types of materials and not all materials are used in every project. Basically i only want to show the colums (when i use the slicer) that have values > 0 I ...
Hi RonaldvdH ,
You need to unpivot the columns（you could create a copy table then do this) :
= Table.UnpivotOtherColumns(#"Changed Type", {"Hoofdproject", "AP gebied naam", "2V_DAC", "12V_MDAC", "24v_LTMC", "48V_LTMC", "96V_LTMC", "192V_LTMC", "LM_EDSA-D4-48", "Woningen", "14/10 connectoren", "Markers", "14/10 eind connectoren"}, "Attribute", "Value")Click Ctrl + the cloumn you want to use：
Then apply and create visual:
Refer:
Did I answer your question? Mark my post as a solution!
Best RegardsLucien
amitchandak but how does that formula or measure prevent a column from being displayed in a visual ?
goodday amitchandak i was hoping you have an answer for me