Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |