Forum Discussion
How to add a filter on report?
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.
- Anonymous9 years ago
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
2 Replies
- parry2k
Super User
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
- AnonymousNot applicable
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