Forum Discussion

parathod's avatar
parathod
Icon for Microsoft Employee rankMicrosoft Employee
7 years ago

Power BI Slicer issue!

Hi Team, In Power BI we have created calculated table that generates number from 0 to 10000 (TopN = SELECTCOLUMNS ( CALENDAR ( 0, 10000 ), "Value", INT ( [Date] ) ) ). We are leveraging this table column in a slicer for customer to select Top N vendors. However the slicer automatically does sampling and shows number in multiples of 10 as in below snapshot. Our customer wants to be able to enter any number between 0 to 10000. For e.g. the customer can enter number 3 or maybe 2156 etc. Any suggestion to overcome this issue? Power BI Slicer Show Data snapshot:

 

Need Help

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi parathod ,

     

    Do one trick, create a index column in Power Query editor and sort your column by index column.
    Note:- For int datatype search option will not visible.

     

     

     

    Thanks,
    Amit

     

     

  • v-yuta-msft's avatar
    v-yuta-msft
    Icon for Community Support rankCommunity Support
    7 years ago

    parathod ,

     

    You may use GENERATESERIES() function instead and create slicer based on the column:

    TopN =
SELECTCOLUMNS ( GENERATESERIES ( 0, 10000, 1 ), "Value", INT ( [Date] ) )

    Community Support Team _ Jimmy Tao

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • v-yuta-msft's avatar
    v-yuta-msft
    Icon for Community Support rankCommunity Support
    7 years ago

    parathod ,

     

    Have you solved your issue by now? If you have, could you please help mark the correct answer to finish the thread? Your contribution will be much appreciated.

     

    Regards,

    Jimmy Tao