Forum Discussion
Change 'Value' data field using a drop down menu
I'm currently using an area chart to display 'spending' over the course of a year. I would also like to display 'saving' in the same chart. My question is it possible to have a drop down menu (or m...
v-yulgu-msft
Microsoft Employee
Microsoft EmployeeHi rlumanlan,
We cannot dynamic choose which column to be displayed in a chart, but as a workarount, we can switch the measure displayed in a chart from a slicer.
Hear is a similar blog for your reference:
Power BI/PowerPivot: Using Slicers to Choose Which Measure to Display
If you still have any concern, please post sample data of your tables.
Regards,
Yuliana Gu