Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 ?
Solved! Go to Solution.
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 .
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
A bidirectional relationship between these two tables (on the Event Type columns), so the overall data model is something like this:
Interested to know if this does what you want.
Regards,
Owen
Hi Owen
@OwenAuger I can't download it for some reason.
Can you please check permissions for the Link
Thanks,
Anil
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
@OwenAuger Thanks Owen for your effort and support. i really appreciate your quick turn around on sharing the report, I don't think this is going to work in my cas as i have 3.6 + billion records involved from DB & these are Query level Parameters ..
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 displa...
using slicers as parameters to allow user input for dynamic query
Dynamic and unique legend, customizable
Best Regards,
Angelia
Angelia,
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.
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
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 .
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
117 | |
101 | |
71 | |
61 |