Forum Discussion

nirvana_moksh's avatar
nirvana_moksh
Icon for Impactful Individual rankImpactful Individual
7 years ago
Solved

Matrix with different format for values

Hello All,   I am running into an issue wherein I am trying to create the below visual which is a matrix. In regards to the data, I have manipulated it by unpivoting the data and getting all 'Colum...
Need Help
Show and Tell
  • v-lili6-msft's avatar
    v-lili6-msft
    7 years ago

    HI, nirvana_moksh 

    You could use FORMAT Function to custom format it 

    Measure = IF(SELECTEDVALUE('Table'[Attribute])="%GROWTH", FORMAT(CALCULATE(SUM('Table'[Value])),"Percent"),FORMAT(CALCULATE(SUM('Table'[Value])),"Currency"))

    Result:

    BeforeAfter

    and here is pbix file, please try it.

     

    Best Regards,

    Lin

v-lili6-msft's avatar
v-lili6-msft
Icon for Community Support rankCommunity Support
7 years ago

HI, nirvana_moksh 

You could use FORMAT Function to custom format it 

Measure = IF(SELECTEDVALUE('Table'[Attribute])="%GROWTH", FORMAT(CALCULATE(SUM('Table'[Value])),"Percent"),FORMAT(CALCULATE(SUM('Table'[Value])),"Currency"))

Result:

BeforeAfter

and here is pbix file, please try it.

 

Best Regards,

Lin

sulovsky's avatar
sulovsky
New Member
6 years ago

Hi,

 

being in the same problem, I have noticed, that in this solution the % fall in grand total (understandably). any intresting trick to avoid it (except for hidint total).