How to turn off a visual on report level filter powerbi

[Anmolgan]

How can we turn off a visual on report level filter in Powerbi?? Can this be possible I know we can do something with edit interacton but here we are talking about turning off the report level filter on a particular visual How this can be done?

[stretcharm]

I'm not sure you can without creating a dax expression or table.

You can use ALL() to give you an unfiltered table

e.g. Create a new Table under Modelling

MyTableUnfiltered = ALL(MyTable) 

You can also create indviudal Measures that ignore filters.

See this post

http://sqlblog.com/blogs/marco_russo/archive/2010/04/05/all-allexcept-and-values-in-dax.aspx

[Anmolgan]

Let me tell you what exactly I am trying to achive here:

1. I have 3 tables first two tables have stacked bar graph and map visualisation both of these tables have 1to1 relation with each of them.

2. I have another table from which a donut chart is coming into play, its related to first table only.

3. I am using edit interactions because I dont want the donut chart to remain as it is and not change by selecting any visualistaion (map or stacked bar graph).

4. I am embedding this application into an application where the user is selecting start and end date values and the map, stacked bar graph and donut chat are changing A/Q to those values, donut chart should remain static but its changing as the filters which are coming from the application are applying in PowerBI as report level filter.

5. Secondly my application also contains a groupid drop down where the user is selecting the groupid and all the visuals (map, stacked bar graph, donut chart) should change A/Q to those visuals, which are changing which is ok.

I need the start and end date which is user typing in into its application and setting in powerbi as report level filter not apply onto the donut chart.

How can I achive this scenrio??

I thought of usign edit interaction but it only support on page visuals not report filters, what can be done inorder to achvie this.

[stretcharm]

I suspect you'll need to use ALL() to get a new table then reapply any filters from slicers or report filters you want to keep.

This could get tricky and without seeing a sample document it's hard for me to give any specific advice.

Look throuhg the blogs on SQLBI as they have lots to help with filtering.

e.g.

https://www.sqlbi.com/?s=filter

https://www.sqlbi.com/articles/the-in-operator-in-dax/

[Anmolgan]

What if I want to use two report filters and want to turn off 1 report filter on a visual?

[v-huizhn-msft]

Hi @Anmolgan,

Up to date, there is no direct button to control which report level filter is used. Please see this feature request and comment on it. If you don't want report level filter [column1] to affect the visual, please use  ALL (Table[column1] ) in DAX.

Best Regards,
Angelia

[Anmolgan]

By making the dax how can I connect a visual of that table to get filter only on specific report level filter?

[stretcharm]

Depends what your doing and how complex your model is.

If you just want a TotalCount that ignores the filter. Add a new measure like this

TotalCount = CALCULATE(COUNT(Execution[ExecutionID]), ALL(Execution) )

If you've got a single table that is filtered on the report.

Create a new table using an expression similar to that in my other post. The replace the fields from the visual with the fields in the new table.

If you model is more complicated with lookups you may want to create a new table with the fields you need. Ensure you use ALL() to remove the report filter.

e.g.

Package Summary =
ADDCOLUMNS (
    SUMMARIZE (
        ALL ( 'Execution Package Stats' ),
        'Execution Package Stats'[PackageName],
        Execution[ServerName]
    ),
    "PackageExecutions", CALCULATE ( COUNT ( 'Execution Package Stats'[ExecutionID] ) )
)