A current limitation in Power BI SWITCH measures (and all Power Pivot actually) is that a SWITCH measure must have a single format. It is currently not possible to conditionally format the measure r...
realquo
Advocate I
6 years agoWell, you can achieve that using FORMAT in your measure definition, e.g. (real example, nth member of a SWITCH clause): values('KPI'[KPI]) = "VA/Ricavi"; format(divide(CALCULATE ( [Importo]; tb_CE[IdTopParent] = 1) + CALCULATE ( [Importo]; tb_CE[IdTopParent] = 7);CALCULATE ( [Importo]; tb_CE[IdTopParent] = 1));"0.00%")
Recent ideas
**BUG** Please fix web model editor UI not working with role-playing dimensions
A key part of complex semantic models is the ability to reuse tables for scenarios like role-playing dimensions (e.g., Date table for DOB, Date table for SalesDate). I've specifically run into this w...arpost3 hours agoPost ProdigyNew4Views0likes0Comments- fbcideas_migusr3 hours agoNew MemberNew326Views10likes3Comments