Show percent change for only most recent period

[Newuser20240515]

Hi folks,

I have the following table. I currently have sales by weeks and % change for all the weeks shown.

But I would like to show the sales for all weeks but the % change for only the last week.

I believe I could hide the older columns if the data was static but difficult to do so as the week progresses.

Categories	202415		202414		202413		202412		202411
	Sales	%Change	Sales	%Change	Sales	%Change	Sales	%Change	Sales
Product 1	50	56%	32
Product 2	62	14%	54
Product 3	30	30%	23

Any suggestion to resolve this issue ?

Thanks in advance!

[v-shex-msft]

HI @Newuser20240515,

You can extract the fact table latest date to store in variable and use this as condition to compare with current date value from matrix column field.

Then you can show the result if current date is the latest date and replace the other result to blank. (power bi visuals will auto hide the fields if whole row/column only existed blank values)

Regards,

Xiaoxin Sheng

[Newuser20240515]

Hi @v-shex-msft, can you share an example on how to do it? Thanks

[v-shex-msft]

Hi @Newuser20240515 ,

Can you please share a some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly  

Regards,

Xiaoxin Sheng

[Newuser20240515]

@powerbihelp