Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

plotting chart with values in multiple column (as pivot chart)

Hi all, Very new to power BI and eager to learn and be involved in the community =) First i will show what i did previously using powerquerry and pivot chart in excel 2016 and then i show where i a...
Need Help
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Just to make things clearer:
Bascially with my source table below (4 columns sourcedata of Date, Price Min, Price Average, Price Max) , 
i like to plot Price vs Month/Day with 9 series of 2017Min, 2017Avg, 2017Max, 2018Min, 2018Avg, 2018Max, 2019Min, 2019Avg, 2019Max.
Prefereably as i have in pivot chart too , a filter for Month.
Thanks Lots

  • v-lili6-msft's avatar
    v-lili6-msft
    Icon for Community Support rankCommunity Support
    7 years ago

    hi, Anonymous 

    According, currently line char/bar chart not support drag multiple fields to legend. These charts' axis and values field support multiple fields for now.
    For your requirement, you can vote below idea and refer to a workaround in it:

    Ability to use multiple fields on a legend like an Excel pivot chart

     

     

    Best Regards,

    Lin