Forum Discussion
Convert Garth to Percentage
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
-------------------------------------------------------------------
-------------------------------------------------------------------------
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.
2 Replies
- MFelix
Super User
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.