Column header as slicer

[Anonymous]

I'm sure this is elementary but I'm stumped. My data is set up with headers like this:

Store Nbr, City, State Sales, LW Sales, LW YAGO, L4W Sales, L4W YAGO, etc.

but need to vizualize it in 3 buckets:

Last Week, Last 4 Weeks and Last 13 Weeks. The idea is to have that slicer and then show the percent change for dollars and units without having to show the whole table. Can someone point me in the right direction?

[v-lionel-msft]

Hi @Anonymous ,

Do you want something like this？

//column
LW/L4W = (P2[ L4W Sales] - P2[ LW Sales]) / P2[ LW Sales] 

Here is my original data table:

If not, maybe you can tell me that what do you want to calculate ?

And which column do you want to filter in a slicer ?
And where is your ‘L13W Sales’ ?

And What does ‘LW YAGO’ mean?

Best regards,

Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Should have made this more clear. The goal is to vizualize LW, L4W and L13W sales vs the same period last year. I can calculate the percentage change but am having no luck with setting up a slicer with LW, L4W and L13W. The data is set up with columns LW, LW Year Ago, L4W, L4W Year Ago, L13W and L13W Year Ago. 

[v-lionel-msft]

Hi @Anonymous ,

"I can calculate the percentage change but am having no luck with setting up a slicer with LW, L4W and L13W. "
Do you mean that you want to use a slicer with multiple columns ? If yes, you can take a look at this article:

https://www.sqlbi.com/articles/creating-a-slicer-that-filters-multiple-columns-in-power-bi/

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Excellent I see how this could work but the Brand and Item Columns are text and the sales are numbers. When I combine them it doesn't seem to work. what am I missing?

[Anonymous]

Here is a sample of my data:

Store Nbr	Store City	Store State/Province	Brand	Segment	POS Sales Last 01 Wk	POS Sales Last 01 Wk YAGO	POS Qty Last 01 Wk	POS Qty Last 01 Wk YAGO	POS Sales Last 04 Wks	POS Sales Last 04 Wks YAGO	POS Qty Last 04 Wks	POS Qty Last 04 Wks YAGO	POS Sales Last 13 Wks	POS Sales Last 13 Wks YAGO	POS Qty Last 13 Wks	POS Qty Last 13 Wks YAGO
			Aw	AEROSOLS										($2)		(2)
			Aw	BATTERY CONTINUOUS	$154	$228	25	38	$667	$735	109	120	$2,059	$2,478	332	419
			Aw	ESSENTIAL MIST	$256	$223	41	31	$857	$693	135	95	$2,416	$2,100	373	304
			Aw	OILS	$865	$1,058	149	178	$3,541	$3,660	605	633	$12,095	$11,124	2,102	1,981
			Aw Vo	AUTOMATIC TOILET BOWL CLEANERS	$12	$60	2	10	$197	$101	33	17	$537	$352	90	59
			Bo	SPECIALTY	$3	$9	1	3	$12	$36	4	12	$77	$104	26	35
			Cn	WATER SOFTENER		$5		1	$21	$16	4	3	$85	$48	16	9
			Dn	MOUSE	$93	$84	13	14	$791	$376	102	52	$1,446	$1,214	176	181
			Eo	APPLIANCE	$122	$118	31	30	$343	$402	87	102	$1,111	$1,076	282	273
			Fh	ADDITIVE	$206	$82	40	14	$566	$294	112	52	$1,751	$1,154	351	198
			Fh	LEGACY					$16		3		$88		16
			Fh	UNIDOSE	$444	$488	69	64	$1,432	$1,609	222	231	$4,360	$5,509	685	814
			Ls	ALL PURPOSE SPRAYS	$151	$174	50	63	$631	$554	218	205	$2,076	$1,867	706	687
			Ls	AUTOMATIC TOILET BOWL CLEANERS	$80	$77	27	27	$355	$346	116	128	$1,335	$1,128	446	411
			Ls	BATHROOM CLEANERS	$89	$68	30	23	$392	$306	132	103	$1,040	$1,143	350	385
			Ls	DILUTABLES CLEANERS	$93	$74	28	24	$419	$392	128	126	$1,423	$1,135	426	368