Convert Garth to Percentage

[Anonymous]

Hello all

Loking for the solution to not create book mark and duplicate my Powerby 8 pages to 16 =(
This formula works in table but not in grath.
Please let me know what i'm doing wrong =(

Formula

-------------------------------------------------------------------

-------------------------------------------------------------------------

[MFelix · Accepted solution]

Hi @Anonymous ,

Your issue is in the use of the format. Using FORMAT transform your calculation into text so you are not abble to show the values in a chart because chart don't show text values.

Believe your best option is to make your measure multiplied by 100 and make a title dinamic:

Dinamic Title = SWITCH(TRUE();
    SELECTEDVALUE(TableAA[Name]) = "Percentage";
    "Percentage %";
    SELECTEDVALUE(TableAA[Name])= "Value";
    "Value Units"
)

Check PBIX file attach.

[Anonymous]

Sorry for the long waiting replay
I had some issues and i could not be around but i want to say tank you for your support 😃 keep doing 5 starts