Forum Discussion
Table with two different formats in the same column. (Accounting (€) + Percentage (%)).wo
How can I reply in the power BI as a Matrix, a collum with two differents formats ?(Accounting (€) + Percentage (%)). It is possible ?
Check out this tutorial - You will have to tweak a bit based on your requirements !!
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.
4 Replies
miTutorialsSuper User
Check out this tutorial - You will have to tweak a bit based on your requirements !!
- aduguid
Memorable Member
Have you looked into dynamic formatting?
https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-dynamic-format-strings
Yes, unfortunately I cannot found information about Percentage + Accouting. It is just in the same format in the types differents.
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.
