Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!View all the Fabric Data Days sessions on demand. View schedule
I have a great formula that change of the measure based on the user selection
The problem is that on this formula we calculate some values as Decimal Number and 2 others as Percentage but when selecting the values that should appear in % they appears as decimal
is there anyway to solve this? that when user select X Measure the values shown as % if they are % or decimal if not
this values should be %
this values are displayed correctly
Solved! Go to Solution.
Hi @Anonymous
Have you tried using Field Parameters? https://docs.microsoft.com/en-us/power-bi/create-reports/power-bi-field-parameters
Hi @Anonymous
Have you tried using Field Parameters? https://docs.microsoft.com/en-us/power-bi/create-reports/power-bi-field-parameters
@Anonymous
It is, you can do that using calculation groups. Take a look at this video from GIAC.
https://www.youtube.com/watch?v=vlnx7QUVYME&ab_channel=GuyinaCube
Towards the end he shows how for format the % measures correctly.
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!