Dynamic field through Filter in matrix visual

[showy]

Hello

I have the following data as shown in the table below (simple Excel with 2 rows and the data shown here)

I want to change the name of the field lvl3 with the filter shareholder.

The following should happen:
If I do not set a filter, the matrix should display Project A.

If I select Company 1 in the shareholder slicer, Project 1 (0.25) should be displayed on the third level (project name + capa of the selected value in the slicer.

If I select Company 2 in the shareholder slicer, Project 1 (0.75) should be displayed on the third level (project name + capa of the selected value in the slicer.

I have already tried it with a field parameter and can switch between lvl3 and show there. But I actually want everything to be controlled depending on the shareholder slicer.

Is that possible?

[v-bmanikante]

Hi @showy ,

May I ask if you have gotten this issue resolved?

If it is solved, please mark the helpful reply or share your solution and accept it as solution, it will be helpful for other members of the community who have similar problems as yours to solve it faster.

Regards,

B Manikanteswara Reddy

[v-bmanikante]

Hi @showy ,

As we haven’t heard back from you, we will go ahead and close this ticket for now.

If you need any further assistance, please don’t hesitate to raise a new ticket, we’re always happy to help.

Our sincere apologies if there was any inconvenience caused.

Regards,

B Manikanteswara Reddy

[v-bmanikante]

Hi @showy ,

May I ask if you have gotten this issue resolved?

If it is solved, please mark the helpful reply or share your solution and accept it as solution, it will be helpful for other members of the community who have similar problems as yours to solve it faster

Regards,

B Manikanteswara Reddy

[v-bmanikante]

Hi @showy ,

May I ask if you have gotten this issue resolved?

If it is solved, please mark the helpful reply or share your solution and accept it as solution, it will be helpful for other members of the community who have similar problems as yours to solve it faster.

Regards,

B Manikanteswara Reddy

[PijushRoy]

Hi @showy 

You can create below measure 

Measure = 
VAR IsShareholderFiltered = ISFILTERED('Table'[shareholder])
VAR ShowValue = SELECTEDVALUE('Table'[show])
VAR Lvl3Value = SELECTEDVALUE('Table'[lvl3])
RETURN
IF(
    IsShareholderFiltered,
    ShowValue,
    Lvl3Value
)

Then pull the measure in the value section of the Matrix table

Or create simple table in place of matrix table

[showy]

Hi,

thanks for your effort.

The problem ist that it has to be in the rows so lvl1, lvl2 and the field with the logic.
In my case it wont work if its a seperatre measure which i can only drag to the value section.

[PijushRoy]

Hi @showy 

CAn you please paste the excel data here, not in form of image

[showy]

Hi i tried but xlsx. is not supported..... why there isnt just a file explorer. I copied the data here. Its just 2 rows with these columns

lvl1	lvl2	lvl3	value	shareholder	capa	show
EU	Germany	Project A	100	Company 1	0,25	Project A (0,25)
EU	Germany	Project A	200	Company 2	0,75	Project A (0,75)

[v-bmanikante · Accepted solution]

Hi @showy ,

Thank you for reaching out to Microsoft Fabric Community Forum.

@PijushRoy Thank you for your quick response.

Could you please provide a bit more detail about your requirement?
It would really help if you could explain:

>>What exactly you're trying to achieve in the visual?

>>What should the output look like when a specific shareholder is selected?

>>And, if possible, can you share a small example of your data along with what the expected result should look like?

Regards,

B Manikanteswara Reddy