Hello EDNA Forum Good Day!
What I’m trying to accomplish
Need to format my YoY % as a percentage in Switch Statement, to show the proper % format in my Matrix visual:
Added [COMP] = 4’s in my switch statement need to modify, so it show as a percentage matrix visual.
Screen shots below
Much appreciate your help!
Please advise of any question.
Thank you
My first attempt to solve formatting issue below
Hello @ambidextrousmentally,
Thank You for posting your query onto the Forum.
It’s always difficult to judge or provide the results based on the screenshots and without looking at the PBIX file. It consumes the time and involves just guess work. While posting the query please ensure that PBIX file is also provided so that members of the forum can provide assistance in a better and efficient manner.
In your measure, you can try the below provided version to achieve the results -
[COMP_ID] = 4, FORMAT( DIVIDE( [MTD CY] - [MTD PY] , [MTD PY] , 0 ) , "0.00% )
Same goes for all the lines where you need to convert it into a percentage form.
Hoping you find this useful and meets your requirements that you’ve been looking for.
Note: If this doesn’t solves your query then please post the PBIX file so that further assistance can be provided.
Thanks and Warm Regards,
Harsh
Hello Harsha
Understood, I can’t get it to work.
Here is my sample .pbix
Sample Financial Data 04 20 22_YoY Percentage.pbix (237.6 KB)
I believe I was able to get what you’re after by wrapping each calculation in a format function.
[SOLVED] Sample Financial Data 04 20 22_YoY Percentage.pbix (238.0 KB)
Hello Zherkezhi
That’s what I’m looking for, initially I was using FORMAT ([YOY%], “Percent”), but couldn’t get it to work.
Much appreciate your help!
Thank you
