Forum Discussion
Conditionnal Number Format
Good evening, I'm working on a dynamic column chart which displays a specific metric depending on the option selected in a separate slicer. Here is the measure used in the Y-Axis to get this resu...
Anonymous I guess selectedvalue is the issue, read this post to get the selected value.
Anonymous this should be your measure (in my opinion)
Dynamic Title - progression annuelle = VAR SelectedValue1 = SELECTCOLUMNS ( SUMMARIZE ( Parameter, Parameter[Parameter], Parameter[Parameter Fields] ), Parameter[Parameter] ) VAR SelectedValue2 = SELECTEDVALUE ( 'Comparables Database - Power BI Dashboard'[Sector] ) RETURN SWITCH ( TRUE (), SelectedValue1 = "EV / Industry Metric", SWITCH ( TRUE (), SelectedValue2 = "Infrastructure", "EV / MW", SelectedValue2 = "Agriculture", "EV / Hectare", "EV / Industry Metric" ), SelectedValue1 = "Discount Rate", "Discount Rate", SelectedValue1 = "EV / EBITDA LTM", "EV / EBITDA LTM", SelectedValue1 = "EV / EBITDA NTM", "EV / EBITDA NTM", SelectedValue1 = "EV / Revenue", "EV / Revenue", SelectedValue1 = "EV", "EV (in M$)" )
Anonymous why you have following line in your expression:
RETURN IF ( COUNTROWS ( SelectedValue1 ) = 1, SelectedValue1 )The line was present in the code proposed in the article you shared with me, that's why I used the expression.