Is it possible to use a line or bar chart that can switch between data types by using a slicer?

[M-Beans]

Hello,

  I'm trying to build a a visual that can represent:

 10 Manufacturing plants

Each have their own Uptime, Capacity utilization, and Plant availability measurements

3 historical years and the current year

I would like the visual to be able to use 1 Line chart or 1 bar chart and have the ability to toggle between

Uptime, capacity utilization, and plant availability.

I currently have a chart that only has uptime, all 10 plants data, and slicers for each plant and year.  

 I have 1 data table for each plant that defines all 3 of those measurements by date ( 10 data tables)

I have a :

plant site table 

Calendar data table

So I can slice by year or plant.  

How do I create the ability to use that single visiual to toggle between Uptime, capacity utilization, and plant availability? 

[parry2k]

@M-Beans I think you are using it differently. Assuming you have three different measures that you want to switch based on the selection.

Create a field parameter and add these 3 measures in the field parameter. Use this field parameter on value and also create a slicer from this field parameter. Based on the selection the visual will change.

[M-Beans]

I'm not sure I fully understand what you are suggesting to do.

I created the field parameter but it's for several plants so I end up with 49 boxes in the fields parameter slicer panel ( a third of them are Uptime for each plant, then capacity utilization for each plant, and Plant availability).  Is there a way for me to configure my data so I can have a slicer panel for :

1) Plant site (with the plant names) - Already created this with a normal slicer

2) Year - Already created this with a normal slicer

3) Uptime, Capacity Utilization, Plant availability ( tried to create this with field parameter by selecting the associated metric for each plant,  I end up with 49 boxes in the fields parameter slicer and no data is populating in the visual when I put this field parameter in the Y Axis, and Date in the X Axis)

[parry2k]

@M-Beans there are many way you can achieve this, easier and faster is to use field parameters. check this out this video to get started on field parameters.  https://www.youtube.com/watch?v=xiRXKZR7-bU&feature=youtu.be

Full playlist is available here: https://www.youtube.com/playlist?list=PLiYSIjh4cEx0_DeQ96QmR1kkgF0WPQscB

[M-Beans]

Hi parry2k,

  Thanks for the reply. 

I watched the video and attempted to try it but it's not working for me.

I need the Y-axis to toggle between Uptime, Capacity Utilization or Plant availability %, by date which is on the X-axis.    When I created the Field Parameter for all plants I end up with 49 boxes to choose from and no display on the Line chart (the field parameter was put in the Y-axis for the visual): 

Any suggestions?