Next 10 Button and Previous 10 Button by categories wise with sales

[chiriazu]

I have visual with category wise sales values. For this visual, as a default view I should show 10 categories by sales. And also I should have a buttons for Next 10 and Previous 10. So this should be dynamic. 

For example: 

In a visual, I am showing categories from 1-10 by sales. When I click next 10 then in the visual it should show 11- 20. Like wise again if i click next 10 then it should show 21-30. 

And now the visual view will be 21-30.

And now again if i click previous 10 then it should show 11-20.

This Next 10 and Previous 10 should be in button or by using parameter.

How to achive this?

[Anonymous · Accepted solution]

Hi @chiriazu 

Want to create Next 10 and Previous 10 with parameters to achieve category switching, it seems that it is not very easy to achieve at present. Because the system has no way to judge the basis of the last switch. Maybe you can do it another way. By writing a serial number to the category, such as 1-10, 11-20, etc., and then adding the serial number to the slicer, filtering is performed.

By writing a serial number to the category, 1-10, 11-20, etc., and then adding this serial number to the slicer . Below is the rendering .

I have attached my pbix file , you can refer to it .

Best Regards,
Community Support Team _ Ailsa Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous · Accepted solution]

Hi @chiriazu 

Want to create Next 10 and Previous 10 with parameters to achieve category switching, it seems that it is not very easy to achieve at present. Because the system has no way to judge the basis of the last switch. Maybe you can do it another way. By writing a serial number to the category, such as 1-10, 11-20, etc., and then adding the serial number to the slicer, filtering is performed.

By writing a serial number to the category, 1-10, 11-20, etc., and then adding this serial number to the slicer . Below is the rendering .

I have attached my pbix file , you can refer to it .

Best Regards,
Community Support Team _ Ailsa Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[chiriazu · Accepted solution]

Thanks for your response @Anonymous . 

I have created a Index column based on the categories and using that index column i have got grouping column on top of grouping column i have created sort column and next to this, by using whatif parameter i have got it in default parameter slicer and on selection of slicer the categories are changing. 

I am happy with your response. Thank you once again

[kumar27]

So , there is a custom visual avaible for your problem.
Check grid by MAQ software , it is pbi certified too . you can changes the configuration to show 10 at a time in one page with next and previous 

Pls accept this as solution .

[chiriazu]

Hi Kumar27, I am aware of this visual(Grid by MAQ), but the same i am expecting with the Line and Clustered Column chart. Is there any workaround to acheive this? Please let me know.

[chiriazu]

No, This scenario i am looking in power bi Visual and not in paginated.

[lbendlin]

Have you considered Paginated Reports?