Forum Discussion

GyMpX's avatar
GyMpX
Frequent Visitor
1 year ago
Solved

filtering a segment filter with select a line in a table

Hello!

 

I just want to have a dynamic filter which take the only value when I select a line in a table. If i select in my table one No sinistre, i only would like to have one No sinistre in the segment filter on the left (the one I selected from the table)

 

 

 

Thank you for your answer

  • Hello GyMpX 

     

    a slicer cannot automatically take on the single value you select from a table row. When you click on a row, that selection will filter other visuals, including the slicer’s available options, but it won’t update the slicer’s selected state. To achieve a similar effect, you can either use the slicer itself in single-select mode instead of the table, rely on table clicks to drive filtering across visuals, or use workarounds like bookmarks, field parameters, or third-party visuals. A common alternative is creating a DAX measure or card to display the selected value rather than trying to force the slicer to change.

     


    If my response helped you, please consider clicking
    Accept as Solution and giving it a Like 👍 – it helps others in the community too.


    Thanks,


    Connect with me on:

    LinkedIn

     

  • Hi Not usre whats top left visual, but I suggest you to use a card visual, pull the No sinistre field in card and apply the condition 

    Create a filter as below 

    if (isfiltered(table) =true(), 

    maxx(ALLSELECTED(Table),Table[No sinistre]), blank())
    and use this measure in Card Visual

5 Replies

  • Hello GyMpX 

     

    a slicer cannot automatically take on the single value you select from a table row. When you click on a row, that selection will filter other visuals, including the slicer’s available options, but it won’t update the slicer’s selected state. To achieve a similar effect, you can either use the slicer itself in single-select mode instead of the table, rely on table clicks to drive filtering across visuals, or use workarounds like bookmarks, field parameters, or third-party visuals. A common alternative is creating a DAX measure or card to display the selected value rather than trying to force the slicer to change.

     


    If my response helped you, please consider clicking
    Accept as Solution and giving it a Like 👍 – it helps others in the community too.


    Thanks,


    Connect with me on:

    LinkedIn

     

  • Hi Not usre whats top left visual, but I suggest you to use a card visual, pull the No sinistre field in card and apply the condition 

    Create a filter as below 

    if (isfiltered(table) =true(), 

    maxx(ALLSELECTED(Table),Table[No sinistre]), blank())
    and use this measure in Card Visual
  • v-sgandrathi's avatar
    v-sgandrathi
    Icon for Community Support rankCommunity Support

    Hi GyMpX,

     

    Thank you srlabhe and pankajnamekar25 for your response.

    Has your issue been resolved?
    If the response provided by the community members addressed your query, could you please confirm? It helps us ensure that the solutions provided are effective and beneficial for everyone. 

    Thank you for your understanding!

     

    • v-sgandrathi's avatar
      v-sgandrathi
      Icon for Community Support rankCommunity Support

      Hi GyMpX,

       

      Just wanted to follow up and confirm that everything has been going well on this. Please let me know if there’s anything from our end.
      Please feel free to reach out Microsoft fabric community forum.

       

      Thank you.

      • v-sgandrathi's avatar
        v-sgandrathi
        Icon for Community Support rankCommunity Support

        Hi GyMpX,

         

        We wanted to follow up since we haven't heard back from you regarding our last response. We hope your issue has been resolved.

        If you need any further assistance, feel free to reach out.

        Thank you for being a valued member of the Microsoft Fabric Community Forum!