Forum Discussion
Change visual format when slicer selection changes
Hi, I have a slicer containing 'lines' and 'percentage'. Dependent on the selection, I want the format of the table visual (see printscreen) to be adjusted to number when lines is selected or per...
Anonymous Are you getting the correct measure with current switch condition?
Yes, it is only presented in percentages when I switch to lines.
Anonymous ok but you are getting lines measure value although it is shown as %, correct?
Yes, that is correct!
Anonymous so you need to use format function to return text value and use format expression based on Line or % selection
Your measure = VAR __yourvalue = <existing switch function> RETURN IF ( SELECTEDVALUE (Table[Your line or % column] ) = "%", FORMAT ( __yourvalue, "Percent" ), FORMAT ( __yourvalue, "General Number" ) )