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 percentage when percentage is selected. How should I achieve this? The values or percentages in the table are a measure selection out of 'slicer_table'.
Table_measure_selection =
SWITCH( UPPER(SELECTEDVALUE(Slicer_table[Key])),
"YTD_OTAE",[YTD % On time or early],
"YTD_OTAE_lines",[YTD_inbound_lines_in_time_or_early],
"YTD_OT",[YTD % On time],
"YTD_OT_lines",[YTD_inbound_lines_in_time],
"YTD_E",[YTD % Early],
"YTD_E_lines",[YTD_inbound_lines_early],
"YTD_L",[YTD % Late],
"YTD_L_lines",[YTD_inbound_lines_late],
"MTD_OTAE",[MTD % On time or early],
"MTD_OTAE_lines",[MTD_inbound_lines_in_time_or_early],
"MTD_OT",[MTD % On time],
"MTD_OT_lines",[MTD_inbound_lines_in_time],
"MTD_E",[MTD % Early],
"MTD_E_lines",[MTD_inbound_lines_early],
"MTD_L",[MTD % Late],
"MTD_L_lines",[MTD_inbound_lines_late],
"RT_OTAE",[RT % On time and early],
"RT_OTAE_lines",[Running_total_on_time_and_early],
"RT_OT",[RT % On time],
"RT_OT_lines",[Running_total_on_time],
"RT_E",[RT % Early],
"RT_E_lines",[Running_total_early],
"RT_L",[RT % Late],
"RT_L_lines",[Running_total_late],
BLANK()
)
