Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
@PARIS2020 , refer
https://www.biinsight.com/power-bi-desktop-query-parameters-part-1/
https://radacad.com/change-the-source-of-power-bi-datasets-dynamically-using-power-query-parameters
https://community.powerbi.com/t5/Desktop/parameterize-connection/m-p/205900#M90712
HI @PARIS2020
Can you please provide more info with screenshots, input and required output in table format for the community so that you ask can be better understood and resolved quickly.
Hope it resolves your issue? Did I answer your question? Mark my post as a solution! Appreciate your Kudos, Press the thumbs up button!! Linkedin Profile |
I have 2 tables :
- a header table Ticket(IdTicket, summarize, Creation-Date, IdStatus)
- detailed table Status (IdStatus, oldStatus, New status, IdTicket)
I need to find records on the Stauts table based on the IdTicket selected.
The IdTicket, appears in a report filter, and when I click on the IdTicket that interests me to select it. Once selected, this filter acts on the Status table to display only the records corresponding to the IdTicket selected.
My problem is that this operation requires retrieving more than 2 million lines, and it does not work well. I would like to be able to click on my IdTicket filter, and the selected value will be passed as parameter of a query that only fetch the values that interest me.
did you manage to find a solution to this ?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
98 | |
75 | |
63 | |
62 |
User | Count |
---|---|
139 | |
104 | |
104 | |
80 | |
66 |