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
Semantic model connection bindings should be in source control (Git)
Semantic model data source connection bindings should be source controlled. A semantic model can contain multiple data source references, each of which can be mapped to a separate Fabric data connec...frithjof_v2 hours agoCommunity ChampionNew10Views1like0CommentsBulk changing column names in Visualizations Pane
We often use raw/api column names or measures with a set nomenclature to be consistent and to keep track of them but we do not want to display these names in the visuals. Currently we have to change ...vishal1401976 hours agoFrequent VisitorNew5Views0likes0CommentsAbout "Download SQL database project" and fix the downloaded project
1. The sqlproj must be fixed, it is downloaded without the xml markup line <?xml version="1.0" encoding="utf-8"> 2. The sdk must be updated: Actual: <Sdk Name="Microsoft.Build.Sql" Version="0.1...Jarrinf15 hours agoFrequent VisitorNew48Views3likes2Comments