Numberic Slicer Ranges - Direct Query

[reetu_k]

Hi All

I have a large dataset with the total requests ranging between 1 - 3 Million using DirectQuery. I would like to introduce a numeric slicer with static ranges like 1-10K, 10 K - 20K etc. Using the default slicer takes too long as it is querying from dataset. 

Any suggestions ?

[Anonymous · Accepted solution]

Hi,

My have three suggestions you can try:

1. create a new column and use IF() function to give all the data a tag, such as "1k-10k", "10k-20k"...;

2. right click the column name and use "new group" to make them into a new bin. Then replace the name in Edit Queries if necessary;

3. Check if the slicer tools in Marketplace may work.