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 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" ) )Hi,
For the table this helps perfectly, but I cannot select the new measure with the flexible format for a line graph. Do you know why? I need that also, so the line graph should also present percentages or lines.
Thanks for your help in advance.
Also the table format is text and not number I believe. I have to sort on totals when the table is showing lines and this is not working oke.