change column using a parameter

Question

I have a table from a select query that has 3 columns date, units, and count.&nbsp;date&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; units&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; count20160225&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 120160226&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;this is how it looks in the table&nbsp;What I'm trying to do is create a chart that will display the dates and the units or the count.&nbsp; I need to use either a parameter or a filter but I'm not sure what is the best.&nbsp; I need to be able to select from a filter or a parameter units; and the line graph will generate a graph for the units, then if I need to select count the graph will change using the count.&nbsp; Can someone please help?&nbsp;Thank you,&nbsp;Antonio Fallucca

anonymous · Accepted Answer

antoniofallucca,You can create a disconnected table to achieve the above requirement. for more details, please review the following PBIX file.https://1drv.ms/u/s!AhsotbnGu1Nogyme9jhSllQtuudLRegards,Lydia

Forum Discussion

change column using a parameter

1 Reply

Related content

Parameter in summarize

Make Parameter effective using calculated column

Parameter slicer with measure for multiple columns

Change parameter with slicer

Converting calculated column into parameter