Forum Discussion
undefined
how can we display only monthly data in power bi report builder
Hi , Anonymous
To filter data in the dataset query, you can include a restriction clause that limits the retrieved data by specifying values to include or exclude from the result set.Use the query designer for the data source to help build a parameterized query.
For a published report, you can use Report subscriptions which you can specify parameter values to filter data and deliver reports through subscription.
You can define a subscription for an on demand or for a snapshot and specify parameter values to use during subscription processing.
- On-demand report. For an on-demand report, you can specify a different parameter value than the published value for each parameter listed for the report. For example, suppose you have a Call Service report that uses a Time Period parameter to return customer service requests for the current day, week, or month. If the default parameter value for the report is set to today, your subscription can use a different parameter value (such as week or month) to produce a report that contains weekly or monthly figures.
For more details, please refer to this documnt.
You may check if this tutorial helps:
https://www.youtube.com/watch?v=YOAMpKK8iy8&list=PLNIs-AWhQzcmEFHyxCRwA_gb29WOz5SJU&index=12
PS: It is recommended to post your question on this reportserver forum
Best Regards,
Community Support Team _ Eason
1 Reply
- v-easonf-msftCommunity Support
Hi , Anonymous
To filter data in the dataset query, you can include a restriction clause that limits the retrieved data by specifying values to include or exclude from the result set.Use the query designer for the data source to help build a parameterized query.
For a published report, you can use Report subscriptions which you can specify parameter values to filter data and deliver reports through subscription.
You can define a subscription for an on demand or for a snapshot and specify parameter values to use during subscription processing.
- On-demand report. For an on-demand report, you can specify a different parameter value than the published value for each parameter listed for the report. For example, suppose you have a Call Service report that uses a Time Period parameter to return customer service requests for the current day, week, or month. If the default parameter value for the report is set to today, your subscription can use a different parameter value (such as week or month) to produce a report that contains weekly or monthly figures.
For more details, please refer to this documnt.
You may check if this tutorial helps:
https://www.youtube.com/watch?v=YOAMpKK8iy8&list=PLNIs-AWhQzcmEFHyxCRwA_gb29WOz5SJU&index=12
PS: It is recommended to post your question on this reportserver forum
Best Regards,
Community Support Team _ Eason