hiding totals of specific column in matrix visual

[jostnachs]

Hi All... I am struggling with matrix visual in power bi where i have to hide some totals and display some as shown below. if i change the color of the text to be white in specifc column setting is not working for me as it changes the header back to white but i need that to be formatted as orange. any idea how i can acheive this and also balck line above the totals.

[Jai-Rathinavel · Accepted solution]

@jostnachs Please pass in the column you have on the row headers insided Selectedvalue in your case it might be Date column

My Sales = 
var a = SUM(FactMyLedger[_Opening])
RETURN
IF(SELECTEDVALUE(FactMyLedger[Date]) <> BLANK() , a,BLANK())

Did I answer your question ? Please mark this post as a solution.

Thanks,

Jai

[Jai-Rathinavel]

@jostnachs If you are using measures to display the columns in the visuals you can include  SELECTEDVALUE() function in your DAX so that it will not show a total row for that metric. If you are using selectedvalue the totals will now show up. Refer my sample dax below

My Sales = 
var a = SUM(financials[ Sales])
RETURN
IF(SELECTEDVALUE(financials[Product]) <> BLANK() , a,BLANK())

Did I answer your question ? Please mark this post as a solution.

Thanks,

Jai

[jostnachs]

i tried and it is giving me all blank values 

[Jai-Rathinavel · Accepted solution]

@jostnachs Please pass in the column you have on the row headers insided Selectedvalue in your case it might be Date column

My Sales = 
var a = SUM(FactMyLedger[_Opening])
RETURN
IF(SELECTEDVALUE(FactMyLedger[Date]) <> BLANK() , a,BLANK())

Did I answer your question ? Please mark this post as a solution.

Thanks,

Jai

[jostnachs · Accepted solution]

Great! Thank you... worked like a charm....