topic Re: Change visual format when slicer selection changes in Desktop

Change visual format when slicer selection changes

Anonymous — Mon, 09 Dec 2019 13:31:10 GMT

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()

)

Re: Change visual format when slicer selection changes

parry2k — Mon, 09 Dec 2019 14:00:56 GMT

Anonymous Are you getting the correct measure with current switch condition?

Re: Change visual format when slicer selection changes

Anonymous — Mon, 09 Dec 2019 14:13:45 GMT

Yes, it is only presented in percentages when I switch to lines.

Re: Change visual format when slicer selection changes

parry2k — Mon, 09 Dec 2019 14:27:59 GMT

Anonymous ok but you are getting lines measure value although it is shown as %, correct?

Re: Change visual format when slicer selection changes

Anonymous — Mon, 09 Dec 2019 14:37:39 GMT

Yes, that is correct!

Re: Change visual format when slicer selection changes

parry2k — Mon, 09 Dec 2019 14:41:12 GMT

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" ) )

Re: Change visual format when slicer selection changes

Anonymous — Tue, 10 Dec 2019 07:14:59 GMT

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.

Re: Change visual format when slicer selection changes

Anonymous — Tue, 10 Dec 2019 07:26:39 GMT

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.

Re: Change visual format when slicer selection changes

parry2k — Tue, 10 Dec 2019 10:16:03 GMT

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.

Re: Change visual format when slicer selection changes

Anonymous — Tue, 10 Dec 2019 10:46:09 GMT

Thanks for the info. Can you help me ahead with achieving this with bookmarks?

Re: Change visual format when slicer selection changes

parry2k — Tue, 10 Dec 2019 10:48:43 GMT

Anonymous this video will help