Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Individual Number Formatting

Hi all,       I was wondering whether there was a way of changing the format of the data so that only the bottom row's numbers show as a percentage, rather than each whole column.   Apologi...
Need Help
  • MFelix's avatar
    MFelix
    8 years ago

    Hi Anonymous,

     

    See below an image of how to do the unpivot and pivot on the query editor.

     

    The selection of the columns for the unpivot should compreend all your months.

     

     

    Regards,

    MFelix

Azhar1's avatar
Azhar1
Regular Visitor
8 years ago

Hi, You can do a conditional formatting in DAX expression for any specific number format.

Try formatting 2 numbers seperately by creating 2 measures, then write a DAX expression using IF condition to use those 2 measures as per the row.

 

Hope this helps.

 

Kind Regards,

Azhar Sayyad