How can I hide measure column in Matix for all months except the last two months

[mamoormasoomi]

Hi,

I am trying to hide the columns in Matix for all months except the last two months.

Please see below the screenshot where I wanna hide only the puple color colums and keep the green color column which is having calculated data for Last two months.

Please help,

Thanks.

[CheenuSing]

Hi @mamoormasoomi

As @v-chuncz-msft there is no such provision in Power BI.

Couple of things to check with you.

The image you have posted has two values for each month being displayed.

Is your requirement  -  cost to be displayed for all months and the difference is to be displayed for last two months ??

Or you want both the cost and the difference to be displayed for last two months ?

WHen you say last two months what is the rule to be applied is it last two months from current month ? or will you be using a slicer to select a month and the output should be for last two months from the selected month.

Cheers

CheenuSing

[mamoormasoomi]

Hi CheenuSing,

Thanks much for your reply.

1. Cost to be displayed for all months and additionally in the last one column added in matrix for displaying the difference for last two months 

2. No Slicer. Just want to display the data for all months (2016 and 2017) and once all the monthwise total displayed in matrix then in the end additional one column display the difference between last two month in the matrix.

3. In my provided table - the last two month are July 2017 and August 2017 so the difference column should display the difference in matix categorywise . Please see below the example table for your reference.

Please let me know if you have any questions.

Regards,

Mamoor. 

Eqp Typ	Svc Dt	COUNTRY	Cost		Diff. Aug vs. Jul
Table	8/18/2017	US	68		68 - (243+68)
Table	7/8/2017	US	243
Table	7/8/2017	US	68
Table	2/22/2017	US	94
Table	12/1/2016	CA	66
Table	11/30/2016	CA	268

[v-chuncz-msft]

@mamoormasoomi,

As far as I know, there is no direct way. You may adjust the column width manually.