Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Dynamically change line chart using slicers

I want to create a line chart which shows multiple lines. The selection is to be done using a slicer.

Consider the following table: 

 

I want to give the user options to select the 2 or more dates and accordingly display 2 or more lines like below:

I have tried making measures or calculated columns but none of them seems to work in the chart.

Need Help

4 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Yes. 

      This solves part of my problem.

       

      Is there any way I can use 2 fields in the Legends section?

      This solves the problem if I have 1 field to choose from (date in this case). If I have 2 or more fields, how will I be able to do it?

      • v-lili6-msft's avatar
        v-lili6-msft
        Community Support
        6 years ago

        hi, Anonymous 

        To my knowledge, It couldn't achieve that use multiple fields on a legend like an Excel pivot chart in power bi for now.

        For your requirement, you may vote for the idea here so this feature might be introduced/rolled out sooner.

         

         

        Best Regards,

        Lin