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
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

BizApps LATAM 2023

Business Application LATAM Summit 2023

Join the biggest FREE Business Applications Event in LATAM this February.

Power Platform Bootcamp

Global Power Platform Bootcamp

In this bootcamp we will deep-dive into Microsoft’s Power Platform stack with hands-on sessions and labs, delivered to you by experts and community leaders.