I'm using the Tree Map object to show the prices of the single components of a bigger object and I would like to add the percentage of those respect to the total price of the object. I tried with '/' and with div, but every time I get "Can't show the chart".
How can I solve this?
Thanks in advance for your help
Solved! Go to Solution.
Use the Number formatting to Number > 12% for the measure.
It depends on the measure you've given.
The output may vary from 12% to 123% or even 1234% but that's the default option already available.
If you expression is
Count(ABC) and the result is 2000, 4321,1234 etc..
Count(ABC)/1000, which should give 20%,43% or 12%... and decimals can be added too in number formatting.
Thanks for your help. My problem is that I can see alteratively the numeric price and the percentage price while I'd like to see both as measures in the same place.
Do you know how could I do that?
Can you share your app and expression you trying/want or perhaps an image of what you need?
Correct me if I'm wrong, you've 2 measures and you do not want to use one of the measure as 'Alternative Measure' but 2 measures as a single measure?
I'm sorry, but unfortunately I can't
It's a treemap where I have the name of the component as dimension and the price as measure and I'd like to see both the numeric price and the total price respect to the total price of the object, but I can only see one of them at a time, also when I try to show them with the &