Hide a measure column in a matrix view

[Pdawar]

Hi all,

In a matrix view, is there a way to hide a measure column for one of the time periods which is LTD? In this case I only want Actuals for LTD and want to hide "vs X" and "vs Y" columns. I have 3 measures in the visual - Actuals, vs X and vs Y. Below is the measure I am using for vs X.

vs X measure =

Var denom = CALCULATE(SUM(KPM_TEST[Total Value]),FILTERS(KPM_TEST[Metric]), KPM_TEST[Version] = "Actuals")

Var Num = CALCULATE(SUM(KPM_TEST[Total Value]),FILTERS(KPM_TEST[Metric]), KPM_TEST[Version] = "X")

return

IF(FILTERS(KPM_TEST[Time Period]) = "LTD", "-", num/denom)

Thanks!

[v-jingzhang]

Hi @Pdawar 

Based on my research and test, this is not available. I cannot find a solution to hide measure values below only one column value. 

Best Regards,
Community Support Team _ Jing