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...
JohnThomas1
6 years agoNew Member
myMeasure = SUMX(MeasureTable,switch([selected measure], 1,{[Total Sales], type currency}, 2,{[Total Cost], type currency}, 3,{[Total Margin], Percentage.Type}, 4,{[Chg Sales vs LY %], Percentage.Type} ))
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...ndaneshi51 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