Forum Discussion
Helper IParameters Values to display ALL
Hi ,
I need some help with the below request.
I have created a Query parameter with below values , for a column from DB called Event Type
A
N
Z
U
I
Now the user is asking me to have another value where it say's ALL
So when the user Select ALL from the List of Values from parameter it will select all Values
New List should have
A
N
Z
U
I
ALL
I don't know how to achieve this , can any one of you help me on this ?
Hi ,
we did a horizontal partition in the DB and included that ALL as another field.
and then it started working for us :)
Hope this helps .
8 Replies
v-huizhn-msftMicrosoft Employee
Hi anilp,
After research and test, we can not achieve your requirement to date. Please vote and comment on this feature request below.
Create a filter option to prevent users from seeing all data on report. Should only allow the display of results based on filter parameter
using slicers as parameters to allow user input for dynamic query
Dynamic and unique legend, customizable
Best Regards,
Angelia
anilpAngelia,
I agree with you after so much of research I posted this questions since I didn't see any other option of asking for help.
Already voted for the ideas you provided.
Thank you so much for your time and suggestions.- v-huizhn-msft
Hi anilp,
It's my pleasure to help you. Could you please mark the useful information as answer, so more people will benefit from here.
Best Regards,
Angelia
- OwenAuger
Super User
Hi anilp
I have set up a dummy model containing an example of how you could achieve this effect.
https://www.dropbox.com/s/lcv72pty7rrfi6m/ALL%20option.pbix?dl=0
This model has
- An Event Type table, containing unique Event Types
- An Event Type Selection table that looks like this:
A bidirectional relationship between these two tables (on the Event Type columns), so the overall data model is something like this:
- When you filter on 'Event Type Selection'[Event Type Selection], selecting ALL will create a filter including all Event Types.
Interested to know if this does what you want.
Regards,
Owen
- OwenAuger
The link should be accessible.
I just tested it in an incognito browser window.
Here is the same link with the "dl=1" option so that it should download immediately on clicking.
https://www.dropbox.com/s/lcv72pty7rrfi6m/ALL%20option.pbix?dl=1
