Filtering Visual

[theo]

Hi everyone,

I'm looking for a way to show the count of specific information using a filter hopefully withou any measure or custom column created since the original data itself is already huge.

example of my current data:

ID number	Average Diff
100000	+00.25 to  +00.50
100001	+00.25 to  +00.50
100002	+00.25 to  +00.50
100003	+00.25 to  +00.50
100004	+00.50 to  +00.75
100005	+00.50 to  +00.75
100006	+00.50 to  +00.75
100007	+00.50 to  +00.75
100008	+00.50 to  +00.75
100009	+00.50 to  +00.75
100010	+00.50 to  +00.75
100011	+00.50 to  +00.75
100012	+00.50 to  +00.75
100013	+00.50 to  +00.75
100014	+00.50 to  +00.75
100015	+00.50 to  +00.75
100016	+00.50 to  +00.75

Visual:

Count of ID	Average Diff
544377	+00.25 to  +00.50
541226	+00.50 to  +00.75
539448	+00.00 to  +00.25
535120	+00.75 to  +01.00

- when I filter this for ID 100000, it will result to 

Count of ID	Average Diff
1	+00.25 to  +00.50

but want to show count of the "average diff" to be shown instead like below.  If possible, no additional measure since I need similar information for about a 1000 columns.  Thanks in advance.

Count of ID	Average Diff
544377	+00.25 to  +00.50

[theo]

Hi @aj1973 ,

Thanks but it provides same result as current filter.

The ID's are unique/distint and there many ID's in the same "average diff" entry.  In my case, , there are around 544377 under this "+00.25 to  +00.50"?

But when I filter with ID 100000, it still results in 1 count (as this is due to the fact that there is only 1 ID 100000).  Is there a prerequisite for this to work?

thanks.

[v-easonf-msft · Accepted solution]

Hi, @theo 

You can try copy a new table "Table2".

Then create a many-to-many bidirectional filtering relationship based on column "Average Diff", and use the ID field in Table 2 to filter the data.

Best Regards,
Community Support Team _ Eason

[theo]

Thanks @v-easonf-msft .

It works, however, I cannot use this to my file because the original table is already huge (original CSV is 62gb)  and it is taking a long time to load and refreshed.  It does provide a partial solution to the problem.

[v-easonf-msft]

Hi,  @theo 

Since you are directly using the ID column of the original table to filter the data, the filtering effect of the visual object is also directly affected by the original table ID. As of now, I am afraid that it is impossible to change the default filtering method without creating a new measure or calculation table.

Even some custom visual objects can't achieve the effect you want.

Best Regards,
Community Support Team _ Eason

[aj1973]

Hi @theo 

You can add Search visual from 

and insert the ID number field in it to search by it.