Table with two different formats in the same column. (Accounting (€) + Percentage (%)).wo

[Robertorufino93]

How can I reply in the power BI as a Matrix, a collum with two differents formats ?(Accounting (€) + Percentage (%)). It is possible ?

[miTutorials · Accepted solution]

Check out this tutorial - You will have to tweak a bit based on your requirements !!

NEW : Dynamic Format String Feature Explained | Add Decimals | Change Currency Symbol | MItutorials ...

[Anonymous · Accepted solution]

Hi @Robertorufino93 ,

You can create measure for this matrix, here's an example.

As you can see, the last row dispaly the percentage of Group B in the total value is shown.

You can try using HASONEVALUE or ISFILTERED to add to the IF statement that returns values in different formats.

ISFILTERED function (DAX) - DAX | Microsoft Learn

HASONEVALUE function (DAX) - DAX | Microsoft Learn

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[miTutorials · Accepted solution]

Check out this tutorial - You will have to tweak a bit based on your requirements !!

NEW : Dynamic Format String Feature Explained | Add Decimals | Change Currency Symbol | MItutorials ...

[Robertorufino93]

Yes, unfortunately I cannot found information about Percentage + Accouting. It is just in the same format in the types differents.

[aduguid]

Have you looked into dynamic formatting?

https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-dynamic-format-strings