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...
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.