Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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.

    https://docs.microsoft.com/en-us/power-bi/paginated-reports/report-builder-parameters#bkmk_Manage_Parameters

     

    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-msft's avatar
    v-easonf-msft
    Community 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.

    https://docs.microsoft.com/en-us/power-bi/paginated-reports/report-builder-parameters#bkmk_Manage_Parameters

     

    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