Visual interaction with table (selectedvalue).

[Anonymous]

Hi, Friends.

I've breaked my brains with a solution, still can't do a simple calcucation (on first sight).

I have by week chart with volumes (packs), data set has max week 15 and min week 7.

Also I have another visual - table with products: [Product name], [Current Week vol], [Previous week vol].

Now comes the hardest. 

What I'm trying to achieve with interactions is - if no bar is selected, then in table week volume for current should be max week available and for previous week its previous one. But when i select a bar (in ex. week 7), then current week should have volume of the 7th and previous week - 6th.

I've gone so far to a measure for previous week as :

[Previous week vol] =

CALCULATE(

SUMX(Sales,Sales[packs]),

FILTER(all('Sales') ,Sales[week_num] = SELECTEDVALUE(Sales[week_num])-1))

)

Now, how do I do a simple IF close, if selected then show selected week bar values, if non is selected- last week in dataset and later to apply it as a filter as true/false - week_num = week_to_display.

[v-frfei-msft]

Hi @Anonymous ,

Kindly share your sample data and excepted result to me if you don't have any Confidential Information. Please upload your files to One Drive for Business and share the link here.

[Anonymous]

My mistake. Here is sample of my data:

area	Sales point	Channel	Product family	Product name	week_number	month_number	year_number	Volume packs
Centre	CEN122	Retail	Family 1	Product 1	13	3	2020	440
North	NOR183	Wholesale	Family 1	Product 1	9	2	2020	1650
North	NOR088	Retail	Family 1	Product 1	12	3	2020	550
East	EAS148	Retail	Family 1	Product 1	10	3	2020	10450
East	EAS251	Key Account	Family 1	Product 1	10	3	2020	1952.5
East	EAS192	Retail	Family 1	Product 1	10	3	2020	9536.45
South	SOU022	Key Account	Family 1	Product 1	10	3	2020	3047
Centre	CEN069	Retail	Family 1	Product 1	10	3	2020	1002.1

Table in report looks like:

Product ID	Week Selected	Previous Week
Product 1
Product 2
Product n

Thanks in advance.

[Greg_Deckler]

Having a difficult time following this. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490