Hello,
I am facing the following issue:
1. created a value prompt set to multiselect
2. Added static choice ( 3 choices reading MUN value)
3. on page explorer added a slicer , to allow multi selection on prompt using 'promptmany' syntax:
Expression:
set(#promptmany('invoiced', 'memberuniquename', '[Sales].[Invoiced].[Invoiced].[Service RevenueType Code]->:[PC].[@MEMBER].[Sales]','','[Sales].[Invoiced].[Invoiced].[Service RevenueType Code]')#)
The following has also been tried:
#promptmany('invoiced', 'memberuniquename')# as detail filter
Problem:
When running report , user can perform multiple selection , but the page does not refresh
Issue is solved, only had to add a reprompt button