Forum Discussion
Values format change
Hi guys, I have a matrix visual which based on the slicer selection shows percent or values. The issue is formating values should be whole number, precent should have % . The data model has the ...
If anyone have similar task, I've done it by using SWITCH and SELECTEDVALUE (based on slicer) then FORMAT (value).
Anonymous , if you are using measure slicer and want the format has to change, you need to use calculation group
calculation groups
https://www.sqlbi.com/blog/marco/2020/07/15/creating-calculation-groups-in-power-bi-desktop/
Thank you amitchandak
Unfortunately, due to company policies I don't have tabular editor or external tools in Pbi.