Disconnet Filter from a specific value of a matrix visual

[Anonymous]

Hello all

I have a matrix table where amongst other values I have my YTD and my FY budget numbers. I do have a slicer where I can select the month i want to review. I guess by default all the values in the matrix table are connected to this month slicer. Is there a way that I can disconnect only the Full Year value? The reason for asking is that -  if for example I select January my YTD will be reflected correct as January YTD but at the same time the full year number will be filtered down  to only Janaury, whereas I want to see the full year.

Thanks

Fanis

[v-eachen-msft]

Hi @Anonymous ,

You could add ALL() function in your DAX to ignore slicer.

Here is the link of this function for your reference: https://docs.microsoft.com/en-us/dax/all-function-dax

[Anonymous]

Hi @v-eachen-msft 

The ALL function did partialy help. I have more than one filters applied to my visual, if I understood correct from the test I did, the ALL function ignores all filters applied, I would need only one filter to be ignored.

Example, the filters I have are Country, Cost Center and Month. I only want the month to be ignored

Thanks

fanis

[v-eachen-msft · Accepted solution]

Hi @Anonymous ,

You could use ALL('Table'[Month]) to ignore month filter and other filters will still work properly.

[Anonymous]

HI @v-eachen-msft 

Brilliant, it worked nicely.

For other users that might be looking at a similar issue. I fist created a new measure SUM of the Full Year Budget and then a second measure where I used CALCULATE and combined it with the ALL function.

Thanks again

FG

[Anonymous]

Hey @Anonymous 

If your January YTD and Full Year are in the same visual then no you cannot do this. However, you can easily put them in separate visuals and then use the "Edit Interactions" in the Format tab in Power BI Desktop to disconnect the slicer from the Full Year Visual. See the article below for additional guidelines on this: https://docs.microsoft.com/en-us/power-bi/service-reports-visual-interactions

If this helps please Kudo.

If this solves your problem please accept it as a solution.