Forum Discussion
Filter
Is it possible to filter data through a row? I have a column containing 60 dates and another 10 columns containing data from different companies. Can I create an area chart/line chart and filter which companies I want to see in the visual?
Hi Saloni,
If I understand you correctly, you may need to use the Unpivot option in Query Editor to unpivot the 10 columns which contains data from different companies to "Company" column and "Data Value" column first, then you should be able to use the "Company" column as filter to get your expected result. Here is an article about unpivot columns for your reference. :smileyhappy:
Regards
2 Replies
look at visual filters - click on your visual and in the right hand of your screen, under where you drag your fields too you should see a visual filter filter... or you can put a slicer on your page, a slicer is the funnel looking object in the visuals but that will apply to all visuals then.
Hi Saloni,
If I understand you correctly, you may need to use the Unpivot option in Query Editor to unpivot the 10 columns which contains data from different companies to "Company" column and "Data Value" column first, then you should be able to use the "Company" column as filter to get your expected result. Here is an article about unpivot columns for your reference. :smileyhappy:
Regards
