Designation : when i select designation from the slicer : it should show designation info in tabl

[Roomie117]

I have a table with multiple columns 

if designation = manager  should show manager related information  
if designation = HR should show HR related information in the table visual.
I split into two tables (manager and CEO)  to get that data and wanted to use two tables into the measure  is there any way we can achieve this?  i wanted to use in table visual 

@PowerBI 

Example :

Manager name, manager experience, address, email, manager worklocation 

HR : 
HR name, Manager Name, HR experience, address ,Email

Not: I am getting all these values in one table for creating measure i split the table into two

[Anonymous · Accepted solution]

Hi @Roomie117 ,

It's suggested that you can try the field parameter feature.

Here's an example.

Drag the fields to the left for filtering.

When you want to display designation = manager, you can select manager fields to display.

When you want to display designation = HR, you can select HR fields to display.

Reference: Let report readers use field parameters to change visuals (preview) - Power BI | Microsoft Learn

Best Regards,

Stephen Tao

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

[suparnababu8]

Hi @Roomie117 

I think you have to create sperate measure for each designation.

Lets take your case

Managermeasure 

Managermeasure = 
IF(SELECTEDVALUE('Table'[Designation]) = "Manager",CONCATENATE(CONCATENATE(CONCATENATE(               CONCATENATE('Table'[Manager name] & ", ",'Table'[Manager experience] & ", " ),
                'Table'[Address] & ", " ),'Table'[Email] & ", "
        ),'Table'[Manager worklocation]
    ),
    BLANK()
)

HR Measure

HRMeasure = 
IF(
    SELECTEDVALUE('Table'[Designation]) = "HR",CONCATENATE(CONCATENATE(CONCATENATE(
                CONCATENATE('Table'[HR name] & ", ",'Table'[Manager Name] & ", "),
                'Table'[HR experience] & ", "),'Table'[Address] & ", " ),
        'Table'[Email]
    ),
    BLANK()
)

Then combine the both measure into a single measure
COmbinedMeasure

CombinedMeasure = 
IF( SELECTEDVALUE('Table'[Designation]) = "Manager",[Managermeasure],
    IF(SELECTEDVALUE('Table'[Designation]) = "HR",[HRmeasure],
        BLANK()
    )
)

Use matrix chart to get correct output.

I hope this helps you

Thanks!

[Roomie117]

This is not working, it is looking for a measure column , unable to add column name in the measure, please let me know if we have any alternatives

[Ritaf1983]

Hi @Roomie117 

Can you please share a pbix or some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly  

[Roomie117]

Manager name	manager division	manager Email	HR full name	HR Email	HR Location & state	Employee	percentage hike	Expected hike	Completed project	employee Rank	Designation
ABC	USA	abc@gml.com	david peter	davidp@gml.com	USA ,NY	hmk	10	30	1	100	Manager
CDE	UK	cde@gmail.com	kevin murphy	kevinm@gml.com	UK,Newport	KLM	15	35	2	80	HR
xab	USA	xab@gml.com	jenny test	jennyt@gml.com	USA ,NY	xxx	20	30	4	100	Manager
yab	UK	yab@gml.com	sarah test	saraht@gml.com	UK,Newport	yyyy	15	35	3	80	HR

when i select Designation= manager it should display values like this 

Manager name	manager division	manager Email	percentage hike	Expected hike	Completed project	Employee
ABC	USA	abc@gml.com	10	30	1	hmk
CDE	UK	cde@gmail.com	15	35	2	KLM
xab	USA	xab@gml.com	20	30	4	xxx
yab	UK	yab@gml.com	15	35	3	yyyy

when i select Designation = HR  form the slicer  it should display values like this  

HR full name	HR Email	Employee	percentage hike	Expected hike	Completed project	employee Rank	Manager name
david peter	davidp@gml.com	hmk	10	30	1	100	ABC
kevin murphy	kevinm@gml.com	KLM	15	35	2	80	CDE
jenny test	jennyt@gml.com	xxx	20	30	4	100	xab
sarah test	saraht@gml.com	yyyy	15	35	3	80	yab

it should display in one table visual.

Thanks for the support 🙂

[Ashish_Mathur]

Hi,

Assuming you already have 2 tables in Power Query - one for Manager and another for HR, create a column in each table (column title as Designation).  Create a Dim table of 2 rows - HR and Manager.  Create a relationship (Many to One and Single) from the 2 Fact tables to the Dim table.  To your slicer, drag Designation from the Dim table and select Manager. 

[Roomie117]

No Ashish,
I have only table but when i select designation  = manager  from the slicer it should show only manager related information in the table visual when i select designation = HR it should show HR related information in the table visual 
columns should change dynamically as per slicer selection .

Thanks
Hamsini