How to add a filter on report?

[raymondxie]

I am very new to PowerBI, I used to use Dundas Dashboard which allows user to create filters like dropdownlist, radio buttons, checkbox, date range etc that actually serves as parameters passed to the data source for the dashboard.

I am wondering if PowerBI has the same or similar functionality of doing that? if yes, it would be appreciated if you can share that with me.

Thank you very much.

[v-shex-msft · Accepted solution]

Hi @raymondxie,

According to your description, I think slicer will be suitable for your requirement.

>> I used to use Dundas Dashboard which allows user to create filters like dropdownlist, radio buttons, checkbox, date range etc that actually serves as parameters passed to the data source for the dashboard.

Radio button: single select

CheckBox: multiple select

DateRange: between mode(only work on date type)

Dropdownlist:

For detail information, you can take a look at the links which parry2k provided.

Regards,

Xiaoxin Sheng

[parry2k]

here are few links related to filter, development of filters are in progress and you will not find radio button, checkbox etc kind of filters yet.

https://powerbi.microsoft.com/en-us/documentation/powerbi-service-how-to-use-a-report-filter/

https://powerbi.microsoft.com/en-us/documentation/powerbi-service-tutorial-slicers/

Date Slicers

http://powerbi.tips/2016/11/grouping-and-improved-date-slicer/

I hope it is helpful and get you going, if need further help, don';t hesitate to ask