How to filter Line Items in a Page Selector

Hi,

I have a module that is used to create a chart on a dashboard. The module has 10 line items and the line items are used as page selectors in chart on my dashboard however I want the page selector to show only 5 of the 10 line items that are relevant to the chart. How can I apply this filter on the line items?

Accepted answers

All comments

brendan_morriso

When you are in Edit Dashboard you will need to click on the chart or module. Once you have clicked on it, on the left hand pane there will be various options for the Page Selectors that are part of that Module. You can uncheck both Show Label and Show Page Selector and the Page Selector. This will remove the Page Selector from your Chart or Module that is published on your Dashboard. Depending on what else is on the Dashboard you may want to uncheck Synchonized Paging as well if it does not make sense to have it on. You will also want to ensure the Initial Page is set to the view that is approriate for the Chart.

Hope this helps

Brendan

RoopaliB

Hi Brendan,

Thank you for your response.

What I want to do it show the drop down in the page selector but limit the drop down menu to only a few relevant line items.

I found a way to do it - pivot the view to show the line items as rows and then selected only the ones you want to show to the user. Pivot the view back to your orginal view with line items as page selector. Then you will see only the relevant line items in the page selector.

brendan_morriso

I misunderstood the question. Glad you were able to find a resolution!

MikhilA

Hi Roopali,

My ask is simialr/same. I want to filter on a lineitem and then i want it to be published on page selector as a different line item on a dashboard. (keeping the filtered lineitem intact) I tried this solution of yours and it seems not to be working. When I 'show only' the relevant line items and then pivot back to the original view, the filter icon display an exclamation mark and shows back the full view of the module, ideally which must not be the case.

Any inputs on this?

Mikhil

RoopaliB

Hi Mikhil,

Are you trying to apply filter and select line items at the same time?

I think if you apply a filter you don't have to manually select the lin items.

MikhilA

Hi Roopali,

No. I am not selecting the lineitems manually. I'm just using the filter and then pivoting as per the view required. When I pivot it to the desired view post selection of the filter, the above icon appears. (as shared in earlier).

Mikhil

Quick Links

Can you help?

Unanswered questions

Not Able to Join the Level 1 Model Building Course
Hey Everyone, I was trying to learn about the Level 1 Model Building Course, when i log in to my system and click on "Start the course" option its showing training unavailable, Can anyone please help me with this @Dikshant and all?
Generating Failure Dump - even though no warnings/error in Actions
I've few actions in our Supply model which when run takes some time on the "generating failure dump" step at the end of the action even though the import is a full success without warning or errors. This is just a few seconds when run for a single action, however we have a process with 120 actions, and most of these…
OAUTH 2.0 vs Google Sheets Extension
Hi, My org is looking to explore leveraging Google Apps script to extract data out of Anaplan and update already built templates in Google Sheets. We use the Anaplan Extension currently but find it crashes often with the amount of tabs, data, etc. Has anyone used both Anaplan OAUTH 2.0 API and Goolge Apps Script to write…