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.
Hello All,
Looking to apply some dynamic formatting to a visual that uses a calculation group to show current-year, prior-year and prior-prior-year... This visual changes measures via a slicer using a parameter table pattern (aka SWITCH function) — In the images below, when I select Retail GP I want the results to be formatted as a number, but when I select Margin I would like the results formatted as a percent.
Hoping the community can help me out! Thanks!
(Still new to posting here so thank you for helping me with proper naming conventions and descriptions!)
Sample DAX formula + Data Results: Need Margin to be a PERCENT when I select "Retail Margin" in the slicer
Solved! Go to Solution.
@1Kash_PBI , Not very clear.
Check if these article can help
https://www.youtube.com/watch?v=vlnx7QUVYME
https://www.sqlbi.com/blog/marco/2020/07/15/creating-calculation-groups-in-power-bi-desktop/
@1Kash_PBI , Not very clear.
Check if these article can help
https://www.youtube.com/watch?v=vlnx7QUVYME
https://www.sqlbi.com/blog/marco/2020/07/15/creating-calculation-groups-in-power-bi-desktop/
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 |
---|---|
42 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
43 | |
39 | |
33 | |
18 | |
17 |