How to set the default value in Report filter pane? | CloudFronts

How to set the default value in Report filter pane?

Posted On October 10, 2019 by Yogesh Gore Posted in

Microsoft Power BI Integrations, in a nutshell, is nothing but a Power BI (business intelligence) software that provides a business analytics solution. It helps companies to visualize their data and to share observations and insights across all the departments in the organizations. Management teams can make crucial decisions based on the information that comes from these reports. 

Your decision making is going to be a lot better and faster when you use this particular software. In other words, it is going to make the life of every employee better as they can see where they are doing well and where exactly they need to improve. Companies can scale up high using the data. 

Here’s everything that you would want to learn about this product

In this blog, we are going to see how to set the default value for value in report filter pane in Power BI.

Sometimes we came with a requirement to set default values in a day filter to Current Month as default.

Since we cannot use DAX in report level filter directly but we can work around this issue in the following way by creating the following DAX

Default Filter = IF(MONTH(Calendar[Date])=MONTH(NOW()) && YEAR(Calendar[Date])=YEAR(NOW()),”This Month”,””)

You can drag the filter in the report level filter and select the value as “This Month”.

Share Story :

By continuing to use the site, you agree to the use of cookies. more information

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.