display table - omit empty fields

[yzhang45]

hi I want to visual a row in table (ie users will always filter to see one item/client at a time)

want to display it "transposed", meaning one field per line

and more importantly omit empty fields (different item/client have different empty fields)

what i tried:

- it seems you can't just transpose the table in visual without transposing the data. I don't want to tanspose the data since it messes up join / data model.

- i can use multi-row card, and make it narrow to force one field per line. But don't know how to make empty field disappear 

[Anonymous]

Hi @yzhang45 ,

Sorry, apart from transposing, there is currently no other good alternative.

Hide column in table visual if contents are 0 | Power BI Exchange .

Hiding columns if blank - Microsoft Power BI Community

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.