Date Slicer Value to show in a matrix column header

[Skane]

I was trying to create a balance sheet report and we have a requirement to show selected value from a  date Slicer in a matrix column headers .There are two date slicer one date slicer column is from table called 'End Date -1' (column Name  'End Date -1') and second date slicer column is from table called 'End Date -2' (column Name  'End Date -2')  and both tables does not have any relationships to transaction table.

For values field i have written a two measure called 'End-Amount 1' and 'End Amount 2' which gets sum of amount for Account number  for less than equal to date selected from a 'End Date 1' slicer and 'End Date 2' and it is working giving me correct results.

I have written a measure to get the selected value from date slicer called 'MSR-End Date 1' and 'MSR-End Date 2'  and since this is a measure i can't use it in column fields in a matrix to show the value selected from date slicer.

So is there any way where i can get the value of a date to show in matrix column headers.?     

[v-angzheng-msft]

Hi, @Skane 

Here's a reference that might help

https://community.powerbi.com/t5/Desktop/Dynamic-column-header-in-Matrix/m-p/954608

Hope this helps.

Best Regards,
Community Support Team _ Zeon Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Skane , you can use two date slicers, But they need to come from two independent date tables.

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

refer

Need of an Independent Date Table:https://www.youtube.com/watch?v=44fGGmg9fHI

How to use two Date/Period slicers :https://www.youtube.com/watch?v=WSeZr_-MiTg

[Skane]

Hello,

1. @amitchandak, I can't share the sample file and data file because it has got sensitive information as well

2.@ v-angzheng-msft , The matrix table has already rows and Measures in values section, I need Measure or any calculated column in matrix column section to show the value of date calendar filter.