varnanavijay Tracker

how to set slicer to select all based on a selection from another slicer

varnanavijay — Mon, 24 Jul 2023 13:24:58 GMT

Hello,

I have 2 slicers 1 and 2 from 2 different tables.

They are in such a way that slicer 1 (single select) shows test1, test2 etc... and slicer 2(multi select with select all) shows different values of test 1 say 1, 2 and select all.

Suppose if I choose test 1 in slicer 1 how would my slicer 2 (with values 1,2 and select all ) go to select all automatically??

Regards,

Varnana

Re: Plot with 2 dynamic slicers inputs combined in legend

varnanavijay — Wed, 19 Jul 2023 08:31:59 GMT

hello,

But I want the visuals to dynamically adapt to user inputs . So thats why put slicers.

Re: Plot with 2 dynamic slicers inputs combined in legend

varnanavijay — Thu, 20 Jul 2023 08:54:39 GMT

Plot with 2 dynamic slicers inputs combined in legend

varnanavijay — Thu, 20 Jul 2023 08:50:48 GMT

.

varnanavijay — Thu, 20 Jul 2023 08:52:56 GMT

Dynamically select first part of a coloumn merge and put that into small multiples.

varnanavijay — Thu, 29 Jun 2023 15:50:16 GMT

Hello Community,

I have a Figure- Curve parameter slicer whose inputs come from figure- curve parameter named parameter field i created from columns of gesamt table. These column are a combination of 2 parameters say for ex Tool- Velocity or Supplier- Temperature . This parameter field is my legend. Now i want to create a column or measure that give the output as the first part of figure-Curve parameter ie in case of tool- velocity it should give tool. so i can put that tool in small multiples and see different tool.

I tried using dax but its not working.

Field =

VAR SelectedParameter = SELECTEDVALUE('Figure - Curve parameters'[Figure - Curve parameters Fields])

VAR FirstField =

SWITCH(

SelectedParameter,

"Velocity-Tool", LEFT(SelectedParameter, FIND("-", SelectedParameter) - 1)

)

RETURN

FirstField

not sure if this is correct also.

Regards,

Varnana

.

varnanavijay — Thu, 20 Jul 2023 08:52:15 GMT