Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.