Column header as slicer

Question

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 · Answer

Hi&nbsp;Anonymous ,&nbsp;Do you want something like this？//column
LW/L4W = (P2[ L4W Sales] - P2[ LW Sales]) / P2[ LW Sales] Here is my original data table:&nbsp;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?&nbsp;Best regards,Lionel Chen&nbsp;If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

anonymous · Answer

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.&nbsp;

v-lionel-msft · Answer

Hi&nbsp;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 ChenIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.&nbsp;

anonymous · Answer

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 · Answer

Here is a sample of my data:Store NbrStore CityStore State/ProvinceBrandSegmentPOS Sales Last 01 WkPOS Sales Last 01 Wk YAGOPOS Qty Last 01 WkPOS Qty Last 01 Wk YAGOPOS Sales Last 04 WksPOS Sales Last 04 Wks YAGOPOS Qty Last 04 WksPOS Qty Last 04 Wks YAGOPOS Sales Last 13 WksPOS Sales Last 13 Wks YAGOPOS Qty Last 13 WksPOS Qty Last 13 Wks YAGO&nbsp;&nbsp;&nbsp;AwAEROSOLS&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;($2)&nbsp;(2)&nbsp;&nbsp;&nbsp;AwBATTERY CONTINUOUS$154$2282538$667$735109120$2,059$2,478332419&nbsp;&nbsp;&nbsp;AwESSENTIAL MIST$256$2234131$857$69313595$2,416$2,100373304&nbsp;&nbsp;&nbsp;AwOILS$865$1,058149178$3,541$3,660605633$12,095$11,1242,1021,981&nbsp;&nbsp;&nbsp;Aw VoAUTOMATIC TOILET BOWL CLEANERS$12$60210$197$1013317$537$3529059&nbsp;&nbsp;&nbsp;BoSPECIALTY$3$913$12$36412$77$1042635&nbsp;&nbsp;&nbsp;CnWATER SOFTENER&nbsp;$5&nbsp;1$21$1643$85$48169&nbsp;&nbsp;&nbsp;DnMOUSE$93$841314$791$37610252$1,446$1,214176181&nbsp;&nbsp;&nbsp;EoAPPLIANCE$122$1183130$343$40287102$1,111$1,076282273&nbsp;&nbsp;&nbsp;FhADDITIVE$206$824014$566$29411252$1,751$1,154351198&nbsp;&nbsp;&nbsp;FhLEGACY&nbsp;&nbsp;&nbsp;&nbsp;$16&nbsp;3&nbsp;$88&nbsp;16&nbsp;&nbsp;&nbsp;&nbsp;FhUNIDOSE$444$4886964$1,432$1,609222231$4,360$5,509685814&nbsp;&nbsp;&nbsp;LsALL PURPOSE SPRAYS$151$1745063$631$554218205$2,076$1,867706687&nbsp;&nbsp;&nbsp;LsAUTOMATIC TOILET BOWL CLEANERS$80$772727$355$346116128$1,335$1,128446411&nbsp;&nbsp;&nbsp;LsBATHROOM CLEANERS$89$683023$392$306132103$1,040$1,143350385&nbsp;&nbsp;&nbsp;LsDILUTABLES CLEANERS$93$742824$419$392128126$1,423$1,135426368

Forum Discussion

Column header as slicer

5 Replies

Related content

column headers as a slicer

Dynamic Column headers

Slicer for filtering several columns

Dynamic Column Header in Visualisation

Line Break in Table Column Headers