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...
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.
Thanks for the info. Can you help me ahead with achieving this with bookmarks?
