Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Hello PBI Community Good Day!
Need to modify [COMP] = 4's in my switch statement to show as a percentage in my pivot table.
Much apprecate your help
Thank you
My Table within the .pbix
My switch Statement
Hi:
Can you use the format option at top of home screen (image below) or
Format % = FORMAT( [YOY %], "Percent")
Hello Whitewater100
I couldn't get it to work. I also created a MTD YoY % measure
User | Count |
---|---|
20 | |
14 | |
11 | |
8 | |
6 |
User | Count |
---|---|
23 | |
23 | |
20 | |
15 | |
10 |