Forum Discussion
Solution SageField Parameters values vs percentages
So I have a a tacked column chart in which I use field paramters to switch between values and percentages.
This is the setting for the labels in this visual:
So Auto which works usually fine.
And for the values it works just fine:
But once you choose % Units :
Of course this is useless.... it just should say 8% and 20%.
Why is it doing this and is there a solution for this?
I know it works when you set 'Display Units' to "None" but then of course the amounts will be big.
So would need another and better solution.
Hello rpinxt ,
try using the new released feature called dynamic formatting to format the percentage measure.
check this https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-dynamic-format-strings
and this https://youtu.be/a3D7oXYjM9k
If I answered your question, please mark my post as solution so it would appeare to others, Appreciate your Kudos👍
rpinxt , Yes in this new feature you can format each measure the way you want.
If I answered your question, please mark my post as solution so it would appeare to others, Appreciate your Kudos👍
3 Replies
- Idrissshatila
Super User
Hello rpinxt ,
try using the new released feature called dynamic formatting to format the percentage measure.
check this https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-dynamic-format-strings
and this https://youtu.be/a3D7oXYjM9k
If I answered your question, please mark my post as solution so it would appeare to others, Appreciate your Kudos👍
rpinxtThanks Idrissshatila , not entirely sure if this is going to help me. But will experiment with it.
These are 2 difference values from which one should be formatted as a percentage and one as thousands.
But as said will experiment.
- Idrissshatila
rpinxt , Yes in this new feature you can format each measure the way you want.
If I answered your question, please mark my post as solution so it would appeare to others, Appreciate your Kudos👍