single measure select multiple value shows in one graph

[Anonymous]

how to show three different values in one graph 

Redution buckts

Ex Rate                      

New Materials

scrap             

values 

0.7       0.17             0.45

0.7       0.27             0.35

0.7       0.17             0.45

Valueof Month                Values 

Dec 2020                        120    -> starting inventory 

Jan                                   121

feb                                   111

March                               121  --> end inventory 

Graph should like below 

any idea .  thanks in advance 

[v-yanjiang-msft]

Hi @Anonymous ,

According to your description, here’s a blog may help to solve your problem.

How to Build A Waterfall Chart to Indicate the Val... - Microsoft Power BI Community

If it still not work, can you provide more details about your data below? What does each data represent?

Best Regards,
Community Support Team _ kalyj

[technolog · Accepted solution]

To show Ex Rate, New Materials and Scrap in one Power BI chart you can use one of three main approaches.

1. Using Field Parameters
   Create a new field parameter in Modeling tab
   Add the three measures Ex Rate, New Materials, Scrap
   Power BI will create a small table with measure names and a parameter measure
   Put Month on X axis, the parameter measure on Values, and the parameter label on Legend
   Add a slicer for that parameter table so you can multi select measures and see them all in one chart

2. Using a disconnected table and SWITCH
   Create a small table with one column Metric and rows Ex Rate, New Materials, Scrap
   Then create one measure Metric Value that checks which metric is selected and returns the corresponding measure value
   For example, SELECTEDVALUE from the Metric column and SWITCH to pick the right measure
   Add Month on X axis, Metric on Legend, and Metric Value as Values
   This way each metric becomes a separate line or bar in the same visual

3. If your data is columns instead of measures
   In Power Query, select Ex Rate, New Materials and Scrap columns and choose Unpivot Columns
   You’ll get columns Metric and Value
   Load that table and build a chart with Month on X axis, Value on Y axis, and Metric on Legend
   Now all three will show together

If your goal is to show start and end inventory with drivers, use a Waterfall chart instead.
Build a small table with Start Inventory, Ex Rate, New Materials, Scrap, End Inventory and mark Start and End as Totals.
Put Step on Category and Amount on Y axis in a Waterfall visual.
You’ll get a clear start to end flow with each factor contributing to the change.

Choose Field Parameters if you have separate measures
Choose Unpivot if your columns are wide
Choose Waterfall if you want to show contribution to inventory change