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!Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.
Hi,
I am new to Power BI. I have one question ,please help. I have a tabular report with dollar values. I need to give an option to the users to display the values in millions, thousands or full number.
In tableau, i create a parameter filter (Create a parameter manually with these 3 options and divide the displayed value by million, thousands or 1 based on user selection) and users can dynamically change it on the report. Is there a way I can do this in Power BI. I have seen the parameter option in power BI , where the parameter selection will appear before the report is generated. Is there a way to get the parameter values as the Slicer values so that users can make the selections within the report same as any other filter?
Thanks for Reading!
Cyril Joy.
Solved! Go to Solution.
This is easy to do using the Paramter table method. Thanks.
@Anonymous
It is not supported by PowerBi currently
Thanks. How do we handle in Power BI If I have couple of filters similar to this?
1. Dollar Display (Milllion, Thousands or Full Amount)
2. Currency (USD, GBP etc)
Thanks.
Cyril.
This is easy to do using the Paramter table method. Thanks.
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the October 2025 Power BI update to learn about new features.