Pass a text parameter in report or some other way.

[SathiMathi]

Hi Leaders,

I am new to Power BI, please help to give your idea how can I achieve this scenario. I am actually confused with measure and parameter then filters. 

Here if user Click on the in-progress count the table will reflect the 3 rows which have only the value = 1 (the table has 3 ones).

same as if user click on the completed number (4) again the table will refresh and fetch 4 records which have been completed.

Please help to give me the idea or solution, 

Thanks for your help.

Click in progress or completed the data will populate in the table view

[GeorgeBuster]

Hi SathiMathi,

Do you want to click a button and filter the table in progress or click other button and filter the table completed?

[SathiMathi]

@GeorgeBuster,

I want to click this number (this is the Sum value of 'in progress'), so user wants to click this number and want to see all in-progress records in the table.

[GeorgeBuster]

Ok SathiMathi,

What you need is the Slicer visualization. Put in it the InProgress attribute, so the users can select if they want to see all records, only in progres records or not in progress records.

Best,

Jorge Bustillo.

[SathiMathi]

Hi,

This is in my 'In Progress' Measure value, based on the following calculation.

InProgress =
SWITCH(LOOKUPVALUE('power_BI UserAccessLevel'[AccessLevel],'power_BI UserAccessLevel'[LoginEmail],USERNAME()),
1,
CALCULATE(SUM('WIP'[InProgress]),
FILTER('FSWIP', 'WIP'[KeyLogin]= LOOKUPVALUE(
'UserAccessLevel'[LoginEmail],
'UserAccessLevel'[LoginEmail],USERNAME()
) )),
2,CALCULATE(SUM('FSWIP'[InProgress]),
FILTER('FSWIP', 'FSWIP'[KeyTeam]= LOOKUPVALUE(
'UserAccessLevel'[Team],
'UserAccessLevel'[LoginEmail],USERNAME()
) )),
3,CALCULATE(SUM('FSWIP'[InProgress]),
FILTER('FSWIP', 'FSWIP'[KeyDept]= LOOKUPVALUE(
'UserAccessLevel'[Dept],
'UserAccessLevel'[LoginEmail],USERNAME()
) )),
4,CALCULATE(SUM('power_BI FSWIP'[InProgress]),
FILTER('FSWIP', 'FSWIP'[KeyBranch]= LOOKUPVALUE(
'UserAccessLevel'[Branch],
'UserAccessLevel'[LoginEmail],USERNAME()
) ))) 

This calculation shows inprogress count based on the login, but if user click on this 'In Progress' number the below table should filter and show only in progress records in table?

Is it possible then please help to advice me, i have tried many ways but still no success.

thanks for the support

[v-shex-msft]

Hi @SathiMathi,

Can you please share a sample pbix file to help us clarify your table structure and relationships?

In addition, did you turn on 'cross filter direction' option between FSWIP table and other related tables?

Regards,

Xiaoxin Sheng