Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more
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!
Solved! Go to Solution.
Hi @Anonymous ,
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.
Check out this article. Let me know if you need further help:
Proud to be a Super User!
Paul on Linkedin.
Hi @Anonymous ,
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.
@Anonymous , 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
Check out the April 2025 Power BI update to learn about new features.
Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.
User | Count |
---|---|
92 | |
60 | |
44 | |
35 | |
34 |