Matrix Dynamic Column headers

[lutat9063]

Hi ,

I have data in below format 

ID	Name	Current Value	Previous Value	Current Fical Year	Previous Year
111	Address	104 Avenue	103 Avenue	FY25	FY24
112	Name	John	Mark	FY25	FY24
113	Name	Ted	Sam	FY24	FY23
114	Address	111 Ave	116 Ave	FY24	FY23

When Fiscal Year Dropdown selected FY25 then matrix  show data in below dyamic format

When Fiscal Year Dropdown selected FY24 then matrix  show data in below dyamic format

[Anonymous · Accepted solution]

Hi @lutat9063 ,
Here's my test data:

1.Create 4 measures

FY24 = 
    CALCULATE(
        MAX('Table'[Current Value]),
        FILTER(
            'Table',
            'Table'[Current Fical Year] = "FY24"
        )
    )

Privious(FY23) = 
    CALCULATE(
        MAX('Table'[Previous Value]),
        FILTER(
            'Table',
            'Table'[Previous Year] = "FY23"
        )
    )

FY25 = 
    CALCULATE(
        MAX('Table'[Current Value]),
        FILTER(
            'Table',
            'Table'[Current Fical Year] = "FY25"
        )
    )

Privious(FY24) = 
    CALCULATE(
        MAX('Table'[Previous Value]),
        FILTER(
            'Table',
            'Table'[Previous Year] = "FY24"
        )
    )

2.Create filed parameter

3.Apply parameter as matrix value
4.Create a Fical Year in Parameter table

Fical Year = IF(Parameter[Parameter Order] = 0 || Parameter[Parameter Order] = 2, "FY25", "FY24")

5. Create slicers based on Fical Year

6.Final output

Best regards,

Albert He

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

[lutat9063]

Test.pbix

[Ritaf1983]

Hi @lutat9063 
Yes, this is possible with a dynamic measures workaround.

Please refer to the linked videos:

https://www.youtube.com/watch?v=zbKNyFu2BOo

https://www.youtube.com/watch?v=6B-n0xM8ZvA

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