Forum Discussion

dramnath_1981's avatar
dramnath_1981
Frequent Visitor
5 years ago
Solved

How to change Label in Matrix visualization

Hi,   I have a matrix visual and with the help of a DAX formula, I arrived at the Variance as a part of the Matrix itself. But unfortunately, I am not sure how to change the Label which says "Total...
  • Pragati11's avatar
    Pragati11
    5 years ago

    Hi dramnath_1981 ,

     

    You can do something as shown below:

     

    Thanks,

    Pragati

     

Pragati11's avatar
Pragati11
Icon for Super User rankSuper User
5 years ago

Hi dramnath_1981 ,

 

You can do something as shown below:

 

Thanks,

Pragati

 

  • dramnath_1981's avatar
    dramnath_1981
    Frequent Visitor
    5 years ago

    Hi,

     

    Currently, I use the below formula to arrive at Variance in the above table which I have posted originally. But one more challenge is, I don't know how do I add Variance % in the last row below variance row.

     

    Any help is much appreciated.

     
    Variance =
    IF (
    ISFILTERED ( Query4[YM] ),
    SUM ( Query4[spends] ),
    CALCULATE (
    SUM ( Query4[spends] ),
    VALUES ( Query4[WK_D] ),
    Query4[YM] = 2020010
    )
    - CALCULATE (
    SUM ( Query4[spends] ),
    VALUES ( Query4[WK_D] ),
    Query4[YM] = 202009
    )
    )