cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
SathiMathi Frequent Visitor
Frequent Visitor

Pass a text parameter in report or some other way.

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.

 

Untitled.pngClick in progress or completed the data will populate in the table view

5 REPLIES 5

Re: Pass a text parameter in report or some other way.

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 Frequent Visitor
Frequent Visitor

Re: Pass a text parameter in report or some other way.

@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.

Re: Pass a text parameter in report or some other way.

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.

Highlighted
SathiMathi Frequent Visitor
Frequent Visitor

Re: Pass a text parameter in report or some other way.

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

Community Support Team
Community Support Team

Re: Pass a text parameter in report or some other way.

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

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |

Helpful resources

Announcements
New Kudos Received Badges Coming

New Kudos Received Badges Coming

Kudos to you if you earned one of these! Check your inbox for a notification.

Microsoft Implementation for Communities Wins Award

Microsoft Implementation for Communities Wins Award

Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Kudoed Authors (Last 30 Days)
Users online (4,878)