Custom Search Visual

Thanks for the reply.

So since it would give the 27 unique items, which will not solve my problem, I have taken the following approach.

Since my idea is to filter for any item say, i want to filter based on country name , then I type the country name , it auto fills the relevant country and once I click the entire page gets filtered for that country. Then If I want to filter based on Segment value say, Consumer Once I type (Con) it auto fills to Consumer and once I click chart gets filtered.

I was able to acheive it. What I tried is Once I get the 27 unique items I have written a js code to remove the duplicates so I get only 9 unique items.(from 27 to 9). Then I use the powerbi-models to filter it. Like when user click on Consumer(a value of Segement) onclick I have written that filter it based on Segment. You can see it in the Following GIF.

As you can see above I have two items in category bucket and I am able to make the functionality. BUt I issue what I am facing now is I need multi filter say if I want to filter one item from category and another from segment I am not able to do it. I know powerbi has a filter api and current;ly i am using basic. It has something called Tuple API.

Once I add it in my code the code stops. as in no error but nothing is happening. Meaning I have wriiten a console.log() above the below code and after it..

let target: ITupleFilterTarget = [
      {
          table: "_Sales Target",
          column: "Category"
      },
      {
          table: "_Sales Target",
          column: "Segment"
      }
  ];
let values = [
      [
          // the 1st column combination value (aka column tuple/vector value) that the filter will pass through
          {
              value: "Technology" // the value for `Category` column of `_Sales Target` table
          },
          {
              value: 'Corporate' // the value for `Segment` column of `_Sales Target` table
          }
      ],
      [
          // the 2nd column combination value (aka column tuple/vector value) that the filter will pass through
          {
              value: "Furniture" // the value for `Category` column of `_Sales Target`` table
          },
          {
              value: 'Consumer' // the value for `Segment` column of `_Sales Target` table
          }
      ]
  ];
console.log('before filter');
let filter: ITupleFilter = {
      $schema: "http://powerbi.com/product/schema#tuple",
      filterType: FilterType.Tuple,
      operator: "In",
      target: target,
      values: values
  }
console.log('after filter');
host.applyJsonFilter(filter, "general", "filter", FilterAction.merge);

Once I run it I see the before filter message and not after filter message. So it means there is something that i am missing or the way i am doing is not correct..

If you could help me out resolving this it would be so helpful. I tried contacting [email protected] but I did not receive any updates. Hoping you would be able to help me in this.

Thanks in Advance.