Forum Discussion

Amanda_44's avatar
Amanda_44
New Member
10 months ago
Solved

Slicer/Filter Mixed Data

Hello,   In a finance dashboard, I have a column that lists multiple funding sources, including combinations. Example rows: Fund A Fund B Fund C Fund A and Fund C Fund B and Fund A   How can...
Need Help
  • v-dineshya's avatar
    v-dineshya
    10 months ago

    Hi Amanda_44 ,

    Thank you for the update. Please provide the sample data, i will explain step by step in detail, that will help you to resolve your issue.

     

    Regards,

    Dinesh

v-dineshya's avatar
v-dineshya
Icon for Community Support rankCommunity Support
10 months ago

Hi Amanda_44 ,

Thank you for reaching out to the Microsoft Community Forum.

 

As you mentioned in your Question, you want to create a slicer that will allow a user to choose all rows with a particular funding source.

 

Please refer below steps.

 

1. Created sample data. Please refer below snap.

 

 

2.  Please refer output snap and attached PBIX file.

 

 

If you want to select “Fund A” in slicer and see all rows containing "Fund A", even if the data says “Fund A and Fund C.”

 

I hope this information helps. Please do let us know if you have any further queries.

 

Regards,

Dinesh

v-dineshya's avatar
v-dineshya
Icon for Community Support rankCommunity Support
10 months ago

Hi Amanda_44 ,

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. And, if you have any further query do let us know.

 

Regards,

Dinesh

  • Amanda_44's avatar
    Amanda_44
    New Member
    10 months ago

    Hi v-dineshya, 

    I appreciate the responses. I was not able to get it to work, but that is probably due to my skill level. I was not able to successfully complete step one with the sample data. 

    • v-dineshya's avatar
      v-dineshya
      Icon for Community Support rankCommunity Support
      10 months ago

      Hi Amanda_44 ,

      Thank you for the update. Please provide the sample data, i will explain step by step in detail, that will help you to resolve your issue.

       

      Regards,

      Dinesh

      • v-dineshya's avatar
        v-dineshya
        Icon for Community Support rankCommunity Support
        10 months ago

        Hi @Amanda_44 ,

        We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. And, if you have any further query do let us know.

         

        Regards,

        Dinesh