Forum Discussion
Conditionnal Number Format
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 there are many ways to solve this:
first, you can use field parameters for the measure selection rather than using a disconnected table (I assume that is what you did)
2nd, you can use dynamic format feature to change the format of the measure based on the selection, check this video on dynamic format:
Thank you very much! I used the field parameters instead of my disconnected table and the number format is working perfectly. However, I got a new problem resulting from the change. The table of my graph was based on this measure :
I adjusted it to reflect the changes I made so it can refer to the parameter chosen :
But I'm getting this error after changing the title measure :
Do you know what may cause this error ?
Thank you very much for your help!