Forum Discussion
How to handle very complex IF statement
Thanks v-easonf-msft and amitchandak for your responses.
The way I have ended up doing it is to instead use if statements that look for blank values, and if it's blank then to show nothing (""), if theres a value then add it in. For example
Combinevalues(" ", If(isblank([v1]), "", "V1: " & [v1] & unichar(10) & unichar(10)), If(isblank([v2]), "", "V2: " & [v2]& unichar(10) & unichar(10)) etc. )
This is working to meet my needs, I just had to repeat it for each column in my calculated column
Hayleysea, If V1 to V7 some member of a dimension, you can unpivot it
https://radacad.com/pivot-and-unpivot-with-power-bi
Transpose: https://yodalearning.com/tutorials/power-query-helps-transposing-data/
And use as Dimension/reference Table
Or If they are measure or columns, You can Use Show on Row in Matrix .
Refer :
https://www.burningsuit.co.uk/blog/2019/04/7-secrets-of-the-matrix-visual/