Forum Discussion
Helper IIDynamic field through Filter in matrix visual
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?
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
9 Replies
showyHi 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) 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
- PijushRoy
Community Champion
Hi showy
You can create below measureMeasure = 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.
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
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
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
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
