Add A Custom Filter

Question

Hi All,&nbsp;I have a table wich shows Total Sales of the branches in a Year 2017 As:&nbsp;Branch&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Sales&nbsp;A&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 120,000&nbsp;B&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 132,504C&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 250,000D&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 150,000Total&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;65,2504 &nbsp; &nbsp; &nbsp;&nbsp;I wanted to add a Custom Filter which will show me Total Year Sales for one branch When the filter in the report is applied to Month Of January Only Like:&nbsp; &nbsp; &nbsp; &nbsp;&nbsp;Report Filtered by January 2017&nbsp;&nbsp; Filter&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Branch&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Sales&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Total Sale for 2017&nbsp;Jan-17&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;A&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;13,800&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;120,000&nbsp;&nbsp;Jan-17&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;B&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;5,960&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;132,504Jan-17&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;C&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;25,690&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;250,000Jan-17&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;D&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;19,500&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;150,000&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Total&nbsp; &nbsp; &nbsp; &nbsp;64.950&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;65,2504&nbsp;Thanks

v-yulgu-msft · Answer

Hi waseemsiddique,
&nbsp;
According to your description, I’m not very sure about what your data model is in the Data View, and what you want to obtain using custom filter. Could you please give more detailed information about "custom filter" and desired output so that I can offer more effective solutions?
If there is ‘month’ or ‘date’ field in your data model, in this case, you could directly add the ‘month’ field to&nbsp;table visual so that you can see total sales per month per year.&nbsp;Besides, to filter table visual based on year/month selection, please add the ‘month’ field to slicer.
&nbsp;
&nbsp;
Best regards,Yuliana Gu

Forum Discussion

Add A Custom Filter

1 Reply

Related content

Add Filter

How to add custom font

Add filter

Add Custom Row (Table.InsertRow)

Add labels to custom shape map