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

 

I did a test, i think this measure doesn't works perfectly, i see the revenue numbers are ok with this measure but the growth% are affecting while filtering the fields in the visual filters, refer below pics

 

 

 

Can you recheck the measure?

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

Hi vjnvinod

 

You may use HASONEVALUE Function to change the total value and then create a new growth% measure with the same way. ALL function could get the total value by ignoring any filters.

 

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.

     

     

      • 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.