Forum Discussion

mp390988's avatar
mp390988
Icon for Post Partisan rankPost Partisan
1 year ago
Solved

How to make the headers in a matrix visual dynamic

Hi,   In the image below, I want those headers I have marked to be dynamic. Specifically,  RevenueForPrevYear should just display "2024" RevenueForCurrYear should just display "2025" RevenueD...
Need Help
  • jaineshp's avatar
    jaineshp
    1 year ago

    Hi mp390988 ,

    Apologies, kindly try to below DAX.

    VAR CurrentYear = YEAR(TODAY())
    VAR PreviousYear = CurrentYear - 1

    RETURN
    DATATABLE("Label", STRING, {
    {FORMAT(PreviousYear, "0000")},
    {FORMAT(CurrentYear, "0000")},
    {FORMAT(CurrentYear, "0000") & " vs " & FORMAT(PreviousYear, "0000")},
    {"%"}
    })

    If this helps, please consider giving it a kudos and marking it as the accepted solution. 

v-pnaroju-msft's avatar
v-pnaroju-msft
Icon for Community Support rankCommunity Support
1 year ago

Thankyou mh2587 , rohit1991 , jaineshp  for your responses.

Hi mp390988,

We appreciate your inquiry through the Microsoft Fabric Community Forum.

We would like to inquire whether have you got the chance to check the solutions provided by mh2587, rohit1991 , jaineshp  to resolve the issue. We hope the information provided helps to clear the query.

Should you have any further queries, kindly feel free to contact the Microsoft Fabric community.
Thank you.