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
F5 for presentation mode in POWER BI DESKTOP
F5 for presentation mode in POWER BI DESKTOP. In design time when we press F5 . 1) The canvas goes to fit to screen mode. 2) Visual headers will be hidden for visual components which set to hidden in...ndaneshi50 minutes agoNew MemberNeeds Votes103Views3likes2CommentsExpose Card Visual Reference Values to DAX via SELECTEDREFERENCEVALUE() or similar
Description The new Card visual introduces Reference Values and Reference Labels, which are excellent for displaying targets, benchmarks, prior periods, and other contextual metrics alongside a KPI....SEMattis1 hour agoAdvocate IIINew2Views0likes0CommentsData Pipelines - Run only selected activities
For debugging and testing pipeline activities during development, allow us to select one or multiple activities and run only the selected pipeline activities. For example, I'm working on editing ...frithjof_v1 day agoCommunity ChampionNew620Views11likes2Comments