Forum Discussion
Change visual format when slicer selection changes
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.
Anonymous with format your data is converted into text and thats why you cannot use it in line graph, to achieve this, you need to create bookmarks to show % and value line graph, you cannot achieve this with one measure.