Forum Discussion
Solved
Report With Specific Filters
I would like to know how to build a report that uses UI controls to select filtering options. I'm lookig specifically for Drop Down Selections and a Date Range Selection.
As well I need to know how to incorporate on the same report and page -- retrieval of data that will be groupued on a date part (like day/month/year)? Sepcifically how can you have a dataset that can be filtered uising this type of grouping (yes my datas source is a SQL DB). And how would you submit the filters to the data set?
I have determined how to do what I was looking for. The paramter configuration provides the ability to provide dynamic paramters that can be used in the query operation. In the Advanced Editor for a query you can integrate dynamic properties.
9 Replies
- Hi petersi,
The options you are refering are a part of the slicer visual that PBI offers when.you add a slicer you can choose from list, drop down, ... depending on the type.of data.
Also when you add a date field in the slicer / visual you can choose from a hierarchy mode (year, quarter, month, day) and date value (all dates are presented). The visuals in PBI work as filters in your reports so when you select different values in a slicer or a table or.graph your data in the report is filtered and calculated accordingly.
Regards,
MFelix
