Use slicer or parameters as variables in 4 Y-axis visual

[Anonymous]

Good Mythical Morning,

Currently investigating if it's possible to create an 4 Y-axis line graph with different dynamic scales to show the value of different sensors over time. I've seen some solutions which use different columns as Y-axis, in this case the different Y-axis contain data from the same column (sensor), but different category like Sensor 1, sensor 2 and sensor 10. The user must be able to choose which sensors are shown in the visual, with a slicer or adjusting parameters. Something like the picture below. 

The current state of the visual is shown in the picture below. Through a slicer the sensors are selected. 

I have tried to use Python and use parameters as variables but so far no succes.

Is there a way to create a visual with 4 Y-Axis, in which an user can select which sensors must be shown (from same column) with a dynamic scale?

The table below contains the data of the second image.

time	ValueOfVal	SensorID
25/11/2020 15:24	308.224	S1
25/11/2020 15:25	308.33	S1
25/11/2020 15:25	308.4996	S1
25/11/2020 15:25	308.6269	S1
25/11/2020 15:25	308.7541	S1
25/11/2020 15:25	308.8814	S1
25/11/2020 15:25	308.9874	S1
25/11/2020 15:25	309.1146	S1
25/11/2020 15:25	309.1994	S1
25/11/2020 15:25	309.3055	S1
25/11/2020 15:25	309.3903	S1
25/11/2020 15:25	309.4751	S1
25/11/2020 15:25	309.56	S1
25/11/2020 15:26	309.6448	S1
25/11/2020 15:26	309.7084	S1
25/11/2020 15:26	309.7932	S1
25/11/2020 15:26	309.8356	S1
25/11/2020 15:26	309.9205	S1
25/11/2020 15:26	309.9841	S1
25/11/2020 15:26	310.0265	S1
25/11/2020 15:26	310.0901	S1
25/11/2020 15:26	310.1537	S1
25/11/2020 15:26	310.1961	S1
25/11/2020 15:26	310.2386	S1
25/11/2020 15:26	310.2598	S1
25/11/2020 15:27	310.3022	S1
25/11/2020 15:27	310.3446	S1
25/11/2020 15:27	310.387	S1
25/11/2020 15:27	310.4294	S1
25/11/2020 15:27	310.4506	S1
25/11/2020 15:27	310.493	S1
25/11/2020 15:27	310.5355	S1
25/11/2020 15:27	310.5567	S1
25/11/2020 15:27	310.5779	S1
25/11/2020 15:27	310.6203	S1
25/11/2020 15:27	310.6627	S1
25/11/2020 15:27	310.6839	S1
25/11/2020 15:29	180692	S2
25/11/2020 15:29	194133	S2
25/11/2020 15:29	208577	S2
25/11/2020 15:29	216417.8	S2
25/11/2020 15:29	228974.2	S2
25/11/2020 15:29	241710.6	S2
25/11/2020 15:29	252215.8	S2
25/11/2020 15:29	262387.2	S2
25/11/2020 15:29	271212	S2
25/11/2020 15:29	271190.2	S2
25/11/2020 15:29	271138.4	S2
25/11/2020 15:29	271082.5	S2
25/11/2020 15:29	270948.9	S2
25/11/2020 15:29	270820.8	S2
25/11/2020 15:29	270662.7	S2
25/11/2020 15:29	270537.3	S2
25/11/2020 15:29	270463.7	S2
25/11/2020 15:29	270401	S2
25/11/2020 15:29	270328.8	S2
25/11/2020 15:29	270289.3	S2
25/11/2020 15:29	270298.8	S2
25/11/2020 15:29	270268.8	S2
25/11/2020 15:29	270229.3	S2
25/11/2020 15:29	270184.3	S2
25/11/2020 15:30	270193.9	S2
25/11/2020 15:30	270213	S2
25/11/2020 15:30	270226.6	S2
25/11/2020 15:30	270198	S2
25/11/2020 15:30	270159.8	S2
25/11/2020 15:30	270166.6	S2
25/11/2020 15:30	270121.6	S2
25/11/2020 15:30	270072.6	S2
25/11/2020 15:30	270052.1	S2
25/11/2020 15:30	270058.9	S2
25/11/2020 15:30	270018.1	S2
25/11/2020 15:30	270023.5	S2
25/11/2020 15:30	269992.2	S2
25/11/2020 15:30	269964.9	S2
25/11/2020 15:30	269914.5	S2
25/11/2020 15:30	269900.8	S2
25/11/2020 15:30	269904.9	S2
25/11/2020 15:30	269857.2	S2
25/11/2020 15:30	269845	S2
25/11/2020 15:30	269879	S2
25/11/2020 15:30	269866.8	S2
25/11/2020 15:30	269858.6	S2
25/11/2020 15:30	269877.7	S2
25/11/2020 15:30	269909	S2
25/11/2020 15:30	269928.1	S2
25/11/2020 15:30	269937.6	S2
25/11/2020 15:30	269997.6	S2
25/11/2020 15:30	269997.6	S2
25/11/2020 15:30	269997.6	S2
25/11/2020 15:30	270004.4	S2
25/11/2020 15:30	270048	S2
25/11/2020 15:30	270118.9	S2
25/11/2020 15:30	270144.8	S2
25/11/2020 15:30	270150.3	S2
25/11/2020 15:30	270161.2	S2
25/11/2020 15:30	270165.3	S2
25/11/2020 15:30	270181.6	S2
25/11/2020 15:30	270199.3	S2
25/11/2020 15:30	270207.5	S2
25/11/2020 15:30	270191.1	S2
25/11/2020 15:30	270255.2	S2
25/11/2020 15:30	270247	S2
25/11/2020 15:30	270279.7	S2
25/11/2020 15:30	270317.9	S2
25/11/2020 15:30	270297.5	S2
25/11/2020 15:30	270375.1	S2
25/11/2020 15:30	270356.1	S2
25/11/2020 15:30	270388.8	S2
25/11/2020 15:30	270398.3	S2
25/11/2020 15:30	270471.9	S2
25/11/2020 15:30	270519.6	S2
25/11/2020 15:30	270668.2	S2
25/11/2020 15:30	270785.4	S2
25/11/2020 15:30	270905.3	S2
25/11/2020 15:30	271004.8	S2
25/11/2020 15:30	270992.5	S2
25/11/2020 15:30	271059.3	S2
25/11/2020 15:30	271104.3	S2
25/11/2020 15:30	271143.8	S2
25/11/2020 15:30	271199.7	S2
25/11/2020 15:31	271237.9	S2
25/11/2020 15:31	271285.6	S2
25/11/2020 15:31	271327.8	S2
25/11/2020 15:31	271284.2	S2
25/11/2020 15:31	271262.4	S2
25/11/2020 15:31	271195.6	S2
25/11/2020 15:31	271229.7	S2
25/11/2020 15:31	271236.5	S2
25/11/2020 15:31	271240.6	S2
25/11/2020 15:31	271243.3	S2
25/11/2020 15:31	271254.2	S2
25/11/2020 15:31	271284.2	S2
25/11/2020 15:31	271282.8	S2
25/11/2020 15:31	271251.5	S2
25/11/2020 15:31	271252.8	S2
25/11/2020 15:31	271202.4	S2
25/11/2020 15:31	271143.8	S2
25/11/2020 15:31	271134.3	S2
25/11/2020 15:31	271122	S2
25/11/2020 15:31	271119.3	S2
25/11/2020 15:31	271105.7	S2
25/11/2020 15:31	271105.7	S2
25/11/2020 15:31	271102.9	S2
25/11/2020 15:31	271062	S2
25/11/2020 15:31	271023.9	S2
25/11/2020 15:31	271018.4	S2
25/11/2020 15:31	270951.6	S2
25/11/2020 15:31	270928.5	S2
25/11/2020 15:31	270928.5	S2
25/11/2020 15:31	270861.7	S2
25/11/2020 15:31	270822.2	S2
25/11/2020 15:31	270760.8	S2
25/11/2020 15:31	270673.6	S2
25/11/2020 15:31	270610.9	S2
25/11/2020 15:31	270579.6	S2
25/11/2020 15:33	372.7545	S3
25/11/2020 15:33	372.78	S3
25/11/2020 15:33	372.78	S3
25/11/2020 15:33	372.6525	S3
25/11/2020 15:33	372.4994	S3
25/11/2020 15:33	372.4483	S3
25/11/2020 15:33	372.4738	S3
25/11/2020 15:33	372.5249	S3
25/11/2020 15:33	372.6014	S3
25/11/2020 15:34	372.7035	S3
25/11/2020 15:34	372.8311	S3
25/11/2020 15:34	372.9331	S3
25/11/2020 15:34	373.0352	S3
25/11/2020 15:34	373.1117	S3
25/11/2020 15:34	373.1628	S3
25/11/2020 15:34	373.2138	S3
25/11/2020 15:34	373.2393	S3
25/11/2020 15:34	373.2904	S3
25/11/2020 15:34	373.2904	S3
25/11/2020 15:34	373.2904	S3
25/11/2020 15:34	373.2904	S3
25/11/2020 15:35	373.3414	S3
25/11/2020 15:35	373.3414	S3
25/11/2020 15:35	373.3414	S3
25/11/2020 15:35	373.3414	S3
25/11/2020 15:35	373.3669	S3
25/11/2020 15:35	373.3669	S3
25/11/2020 15:35	373.3414	S3
25/11/2020 15:35	373.3159	S3
25/11/2020 15:35	373.2904	S3
25/11/2020 15:35	373.2648	S3
25/11/2020 15:39	1	S4
25/11/2020 15:39	1	S4
25/11/2020 15:40	1	S4
25/11/2020 15:40	1	S4
25/11/2020 15:40	1	S4
25/11/2020 15:40	1	S4
25/11/2020 15:40	1	S4
25/11/2020 15:40	1	S4
25/11/2020 15:41	1	S4
25/11/2020 15:41	1	S4
25/11/2020 15:41	1	S4
25/11/2020 15:41	1	S4
25/11/2020 15:41	1	S4
25/11/2020 15:41	1	S4
25/11/2020 15:42	1	S4
25/11/2020 15:42	1	S4
25/11/2020 15:42	1	S4
25/11/2020 15:42	1	S4
25/11/2020 15:42	1	S4
25/11/2020 15:42	1	S4
25/11/2020 15:43	1	S4
25/11/2020 15:43	1	S4

[v-henryk-mstf · Accepted solution]

Hi @Anonymous ,

Currently, Powerbi Desktop does not support four y axis in the default visual that comes with it. Sensors can be filtered through the slicer, which dynamically reflects the change curve of different SensorIDs over time. I did the following test: 

If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.

Best Regards,
Henry

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.