Remove a measure from all the columns in a matrix , just need it at the end

[Anonymous]

Hi there!

I just created a measure for the difference between Q12020 an Q12021 in my matrix, but I don't want the calculation in all the columns, I just want it at the end

[Anonymous · Accepted solution]

Hi @Anonymous 

I have no way to completely restore the data in your visual, but I know a way to hide the measure you do not need .

(1)Choose the visual ,and turn off  “Word wrap” in Visualizations if the measure in Values.

(2)Choose the measure column you do not want to hide it .

The effect is as shown:

Best Regards

Community Support Team _ Ailsa Tao

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

[selimovd]

Hey @Anonymous ,

when you put it in the values and you put the years in the columns it will always calculate for all the years.

You could only give blank back if it's not the last year, but the column header will still appear.

 If you need any help please let me know.

If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi