topic Re: Next 10 Button and Previous 10 Button by categories wise with sales in DAX Commands and Tips

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

chiriazu — Thu, 14 Jul 2022 10:06:21 GMT

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?

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

lbendlin — Sat, 16 Jul 2022 23:12:12 GMT

Have you considered Paginated Reports?

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

chiriazu — Mon, 18 Jul 2022 05:57:43 GMT

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

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

kumar27 — Mon, 18 Jul 2022 06:03:27 GMT

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 .

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

chiriazu — Mon, 18 Jul 2022 09:19:12 GMT

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.

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

Anonymous — Wed, 27 Jul 2022 09:21:25 GMT

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.

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

chiriazu — Wed, 27 Jul 2022 09:32:59 GMT

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