Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello everyone.
I would like to set a Data segment where, depending of the Filter of another one, an specific column of my database appears.
Example:
If in Data segment 1, I select the choice one, then the Data segment 2 have to show the column "1".
If in Data segment 1, I select the choice two, then the Data segment 2 have to show the column "2".
Etc.
How can I do this?
Thanks a lot for your help.
Regards.
Solved! Go to Solution.
Hi @demian-cr ,
I made a simple table as below:
First create an index column in query editor;
Then suppose col1 is the defaulting showing column,create a measure as below:
Measure =
IF(NOT(ISFILTERED('Table (2)'[Column1])),MAX('Table'[Col 1]),SWITCH(SELECTEDVALUE('Table (2)'[Column1]),
"Col 1",MAX('Table'[Col 1]),"Col 2",MAX('Table'[Col 2])))
And you will see:
For the related .pbix file,pls see attached.
Best Regards,
Kelly
Did I answer your question? Mark my post as a solution!
Hi @demian-cr ,
Could you pls provide some sample data with expected output to make your requirement clear?
Best Regards,
Kelly
Did I answer your question? Mark my post as a solution!
Hello @v-kelly-msft
Thanks a lot for your help.
For example:
I have a dropdown list, and near to it, I have a table that only shows an specific field of the table.
Then, if I change the choice selected in the dropdown, I would like that the data segment where the table is, shows another field.
I mean, each time the choice of the dropdown change, the field showed in the table has to change too.
Do I explain myself?
Regards.
Hi @demian-cr ,
I made a simple table as below:
First create an index column in query editor;
Then suppose col1 is the defaulting showing column,create a measure as below:
Measure =
IF(NOT(ISFILTERED('Table (2)'[Column1])),MAX('Table'[Col 1]),SWITCH(SELECTEDVALUE('Table (2)'[Column1]),
"Col 1",MAX('Table'[Col 1]),"Col 2",MAX('Table'[Col 2])))
And you will see:
For the related .pbix file,pls see attached.
Best Regards,
Kelly
Did I answer your question? Mark my post as a solution!
Hi @demian-cr ,
I made a simple table as below:
First create an index column in query editor;
Then suppose col1 is the defaulting showing column,create a measure as below:
Measure =
IF(NOT(ISFILTERED('Table (2)'[Column1])),MAX('Table'[Col 1]),SWITCH(SELECTEDVALUE('Table (2)'[Column1]),
"Col 1",MAX('Table'[Col 1]),"Col 2",MAX('Table'[Col 2])))
And you will see:
For the related .pbix file,pls see attached.
Best Regards,
Kelly
Did I answer your question? Mark my post as a solution!