Ignore Slicer filter on matrix visual Rows but should apply on Values

[Anonymous]

Hello All,

I have a data as below 

Power Query to generate data.

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("jdLLCsIwEAXQXyldR8ijycSlsb61Fbel+P9/YZOZKC68CJ3bFM5AOsk0tVZb/dTUqnaT+iXTYxzyx1LLY72RnNVPm9gao3QXPwvQsZUOipLA9my9J0lgd2x1KeD27NalgDuwI+WDfb+BP7J3jgPIU65m1eQ5U96HC3DH1ac//Vkm3AVJYC9sQyngrjK1SJLA3uTUSEsCO9T7YySBHevNIUlg77lkxiF2JeEP1ob03TC/AA==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) in type table [YearPeriod = _t, SourceName = _t, DestinationName = _t, Platform = _t, ModelScenarioName = _t, #"History Cases" = _t, #"Model + Scenario Cases" = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"YearPeriod", type text}, {"SourceName", type text}, {"DestinationName", type text}, {"Platform", type text}, {"ModelScenarioName", type text}, {"History Cases", Int64.Type}, {"Model + Scenario Cases", Int64.Type}})
in
    #"Changed Type"

I am using matrix visual, and i dragged Source, Destination, Platform, ModelscenarioName in Rows, and Year in Columns and Historycases and Model+Scenario Cases in Values.

From slicer Modelscenarioname, whenever i choose some value, it will filter out all the related values of Source, Destination, Platform, ModelscenarioName.

What i am trying to get is, whenever i choose modelscenarioname, it should not filter out any of the Source, Destination, Platform, ModelscenarioName values but it should filter and show the sum value of historycases and model+scenariocases for only that selected model scenario name.

Any suggestions please.

Thanks,

Mohan V.

[Anonymous]

HI @Anonymous 

Looks like an unique ask.

What I would do is to create a measure to return 1 for selected value and 0 otherwise.

and on the visual go to format pane and in conditional formatting backgroung and text color as white so that even though the data is present it will hide from plain view.

[amitchandak]

@Anonymous , if you do not it filter, you use edit interaction of all

https://docs.microsoft.com/en-us/power-bi/create-reports/service-reports-visual-interactions

calcullate([measure],all(Table[modelscenarioname])

https://www.linkedin.com/pulse/five-recent-power-bi-functions-you-should-use-more-often-amit-chandak

In case you want swap measure on use isfiltered

if(isfiltered(Table[modelscenarioname]), [Measure1],[measure2])

https://powerpivotpro.com/2013/03/hasonevalue-vs-isfiltered-vs-hasonefilter/