cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
eugeniaCastilla
Frequent Visitor

Apply a value in matrix to one column only

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... 

 

eugeniaCastilla_0-1647859651390.png

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!

1 ACCEPTED SOLUTION
v-chenwuz-msft
Community Support
Community Support

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:

vchenwuzmsft_0-1648107209526.png

 

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.

View solution in original post

3 REPLIES 3
PaulDBrown
Super User
Super User

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... 





Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.






v-chenwuz-msft
Community Support
Community Support

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:

vchenwuzmsft_0-1648107209526.png

 

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
Super User
Super User

@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

Helpful resources

Announcements
November 2022 Update

Check it Out!

Click here to read more about the November 2022 updates!

Microsoft 365 Conference â__ December 6-8, 2022

Microsoft 365 Conference - 06-08 December

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.