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...
dabu1
5 years agoNew Member
I have read all comments in this tread and here is mine opinion: 1. Improved FORMAT() function could be solution, if this function would provide correct datatype & formatting. Not text as is now. (why, see Conditional formatting, Charts and etc.) Master Measure:= IF(SelectedValue(Slicer[Value])=1, FORMAT([Measure1], "0,00"), FORMAT([Measure2], "0,0%")) 2. Solution could be to implement logic of inherent (parent) property in Measure tools => Format => (General, Currency, ...., Parent format). It can be allowed only in case of stand-alone(pure) measure re-reference within IF(), SWITCH(): Master Measure:= IF(SelectedValue(Slicer[Value])=1,[Measure1], [Measure2]) In case of following := [Measure1] + [Measure2] - or similar, it should produce simple: Error in resolving parent formatting. Please select correct one. 3. What we then get (Yes, it’s more view & user experience): 3.1. Usage of Master Measure (MM) (which combines many measures (kpi) with help of IF()/SWITCH()); 3.1. With help of slicer/visual in report user can select kpi in other visuals with MM (MM "reacts" on selected value in slicer); 3.2. In combination with parameter table(even sub-model) - where all measures of MM are listed - it’s possible to create: a) groups and lists of kpi's / master kpi and child kpi's of group (off/on) / custom drilldown b) user in slicer(if slicer and visual are based on parameter table field) can select needed kpi's, preferred layout, group of kpi's (depends on parameter table and slicer(s) in report); c) parameter table allows to set kpi's allowed to see for the user (it is "row-level-security for the measure", especially if report visuals use only MM); d) once report is developed, in some cases kpi's can be changed/added only with changes in MM and in parameter table. I'm sure, other can add more ... Hope, this will help us to get this nice feature faster! Vote !!!
Recent ideas
Programmatic point-of-failure recovery for Fabric pipelines
The Fabric monitoring UI already supports Rerun → rerun from failed activity. That capability is only reachable by a human clicking in the portal. Please make point-of-failure recovery available to a...EversonElias2 hours agoRegular VisitorNew2Views0likes0CommentsEnable Managed Private Endpoints Support for Microsoft Fabric Capacities Below F64
Managed Private Endpoints in Microsoft Fabric are currently supported only on F64 and higher capacities. Customers using lower capacities, such as F8, cannot establish private connectivity to Azure s...v-tsindhu4 hours agoMicrosoft EmployeeNew6Views0likes0CommentsAccessibility bug: Notebook cell text becomes invisible under Windows 11 High Contrast mode
Any text written inside a Fabric notebook is invisible when Wndows High contrast mode is enables. This applies to cell text only (not the UI). In addition, auto-complete windows are not respecting t...abigb5 hours agoNew MemberNew3Views0likes0Comments