Hide a measure column in a matrix view

Pdawar — Mon, 17 Apr 2023 12:59:01 GMT

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!

Re: Hide a measure column in a matrix view

v-jingzhang — Wed, 19 Apr 2023 02:37:41 GMT

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

topic Re: Hide a measure column in a matrix view in DAX Commands and Tips

Hide a measure column in a matrix view

Re: Hide a measure column in a matrix view