Apply a value in matrix to one column only

[eugeniaCastilla]

Heelo everyone!

I was wondering... I don't even know if this is possible but it is worth a try...

I have a matrix with some names as rows, years as columns and some values. 

I have been asked to change the configuration of the matrix so that one of the values only appears for the current year, and not for the rest of the columns. I don't know if I am making myself very clear... 

This is the header of my matrix, and what I would like is for the measure "Dif. Inv. Ant" to appear only for the column 2022 and not for the other years...is this possible? 

Thanks in advance!

[PaulDBrown]

Check out this article. Let me know if you need further help:

https://community.powerbi.com/t5/Community-Blog/Creating-a-custom-or-hybrid-matrix-in-PowerBI/ba-p/1... 

[v-chenwuz-msft · Accepted solution]

Hi  @eugeniaCastilla , 

There is no way to directly modify only the measure to be applied to a column. Even if the result of the measure is empty, there will still be a space in that column.
We can do this by modifying the Columns of the matrix. Use the following formula to create a custom column for the matrix.

Year = union(VALUES('Table'[Date].[Year]),{"Dif.Inv.Ant"})
 
Then, we use a measure called the merge measure as the values of the matrix table.
merge measure =

IF ( SELECTEDVALUE ( 'Year'[Year] ) = "Dif.Inv.Ant", CALCULATE ( [Dif.Inv.Ant], FILTER ( 'Table', [Date].[Year] = YEAR ( TODAY () ) ) ), [Inv.Act] )

The result looks like this:

Pbix in the end you can refer.

Best Regards

Community Support Team _ chenwu zhu

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

[amitchandak]

@eugeniaCastilla , You can create a calculation group of you measures and have code for measure you want to hide like

if(Max(Date[Year]) =2021 ,[Measure2], blank())

Other can be simply the measures

I have not tested this

calculation groups
https://www.sqlbi.com/blog/marco/2020/07/15/creating-calculation-groups-in-power-bi-desktop/

Calculation Groups- Measure Slicer, Measure Header Grouping, Measure to dimension conversion. Complex Table display : https://youtu.be/qMNv67P8Go0