Forum Discussion

nirvana_moksh's avatar
nirvana_moksh
Impactful 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
Community 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).

  • corange's avatar
    corange
    Post Patron
    6 years ago

    Hi, 

     

    This works well. My table is set up with Client Name at the row level and then on the column level you have attribute into two categories (revenue  / job count) and further broken down into Month, Period and Date when you drill down in the matrix visual. 

     

    I have used your formula to format accordingly value for Revenue in Currency. However, when I use the measure, it will show me all the date I have in the calendar. It is like it doesnt respond to any slicer I have got one anymore. 

     

    Any idea how to fix this? 

     

    Thank you