Forum Discussion
Dynamic Formatting + Calculation Group + Slicer Using Parameter Table Pattern for Different Measure
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
GP formatted as expectedMargin needs to be a percent
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/
1 Reply
- amitchandakSuper User
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/