Forum Discussion

vjnvinod's avatar
vjnvinod
Impactful Individual
7 years ago
Solved

Table visual help

Dear community,   Take a look at the below pic. its a table visual in power BI my problem is, i need to hide or filter out some fileds lets say the one you see here "im" which has -57.1M. while we...
Need Help
Show and Tell
  • v-cherch-msft's avatar
    v-cherch-msft
    7 years ago

    Hi vjnvinod

     

    Just turn off the 'Row subtotal'.

     

    Regards,

    Cherie

vjnvinod's avatar
vjnvinod
Impactful Individual
7 years ago

v-cherch-msft

 

thanks for this, i think i am not able to follow.

Can you share the pbix file? for me to take a look, to know how you arrived at ignoring filters for the growth.

 

thanks for your help.

 

 

  • v-cherch-msft's avatar
    v-cherch-msft
    Microsoft Employee
    7 years ago

    Hi vjnvinod

     

    Create Growth.2 measure for your reference. Here is the sample file.

     

    Regards,

    Cherie

  • vjnvinod's avatar
    vjnvinod
    Impactful Individual
    7 years ago

    v-cherch-msft

     

    Hi, thanks for this, but when i looked at it, i noticed again that revenue numbers are correct, however the Total growth rate is not correct.

    that means that my total should be 851M and growth should be at 2.3% but your measure output is total at 851M and growth rate is at 2.5%.

     

    Can you have a look below and share the updated pbix file, for me to check, if it works?

    Appreciate your expertise & help to fix this.

     

  • vjnvinod's avatar
    vjnvinod
    Impactful Individual
    7 years ago

    v-cherch-msft

     

    superhelpful, one  quick question as well

    if i want to take/remove the last line, which is Total, is there a way to do that in power BI?

     

    thanks for your help

  • v-cherch-msft's avatar
    v-cherch-msft
    Microsoft Employee
    7 years ago

    Hi vjnvinod

     

    Just turn off the 'Row subtotal'.

     

    Regards,

    Cherie