Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
how can we display only monthly data in power bi report builder
Solved! Go to Solution.
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.
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
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.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.